Disable immediate window (i think)
 

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

Disable immediate window (i think)
 

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.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Steven Revell" wrote in message
...
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

Disable immediate window (i think)
 

Not and still allow them to use VBA.

--
Regards,
Tom Ogilvy


"Steven Revell" wrote in message
...
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

Disable immediate window (i think)
 

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 R. Dodge, Jr.
Production Statistician
Master MOUS 2000
"Tom Ogilvy" wrote in message
...
Not and still allow them to use VBA.

--
Regards,
Tom Ogilvy


"Steven Revell" wrote in message
...
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

Disable immediate window (i think)
 

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.

--
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
"Ronald Dodge" wrote in message
...
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 R. Dodge, Jr.
Production Statistician
Master MOUS 2000
"Tom Ogilvy" wrote in message
...
Not and still allow them to use VBA.

--
Regards,
Tom Ogilvy


"Steven Revell" wrote in message
...
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