| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent code running
Anytime you need to prevent code, be it in an event or not, from running in
particularcirumstances, you can do this by: 1, Create a Boolean Public variable, say bWatchSandyRun 2. Set the value to vbTRue or vbFalse,as needed. 3. With the code block, be itt event code or not, test the bWatchSandyRun to detertmine when code should run. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to prevent vba code from running? | Excel Programming | |||
| hide/protext auto_open code so user can't prevent it from running | Excel Programming | |||
| how to prevent code running when in a worksheet code | Excel Programming | |||
| Prevent code in "Sheet Activate" from running when sheet made visible from other macr | Excel Programming | |||
| Prevent others from running my macros | Excel Programming | |||
Threaded Mode
