Disable immediate window (i think)

[Steven Revell]

Hi,

I want the users to not be able to run commands such as:

application.enableevents = False
application.displayalerts = False

is there any way to do this.

Thank you in advance for any help!

Regards,
Steven

 

[Chip Pearson]

Steven,

I don't think there is any way to prevent the users from accessing the
Immediate Window, nor do I think there is any way to prevent them from
running commands directly in the VBE.

 

[Tom Ogilvy]

Not and still allow them to use VBA.

 

[Ronald Dodge]

There is no way to my knowledge in Excel to prevent this. In Access, there
is a way, but that would only be by converting an MDB file to an MDE file.

 

[Ronald Dodge]

Sorry Tom, didn't mean to post it under your thread as I meant to post it
under Steven's original start to this thread, so please, don't take this as
if I'm saying that you were incorrect or something of that nature.