| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to save a desired window size but hv window comeup fullsz by d | Excel Discussion (Misc queries) | |||
| View cell contents as a pop-up window (similar to comments window) | Excel Worksheet Functions | |||
| Docking Project Explorer, Properties window and Code window in VBE | Setting up and Configuration of Excel | |||
| The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
| How do I disable the Margins button in Print Preview Window | Excel Programming | |||
Hybrid Mode
