| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to deactivate cells without macro references
How to deactivate cells which are not used by macro but when I change
something there most of my macros start running. I can do changes only when I switch to design mode. How to make so, that the changes in the cells wouldn't start macro? And how to do so, that when I change a value in drop-down menu which doesn't contain macros it wouldn't start macros of another drop-down menu? Thank you for the help! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to deactivate cells without macro references
If you're designing this workbook, maybe just disabling events (temporarily)
would be sufficient. Alt-f11 (to get to the VBE where macros live) ctrl-g (to see the immediate window) Type this and hit enter: application.enableevents = false Change it to true when you're ready to test your workbook. Adomas wrote: How to deactivate cells which are not used by macro but when I change something there most of my macros start running. I can do changes only when I switch to design mode. How to make so, that the changes in the cells wouldn't start macro? And how to do so, that when I change a value in drop-down menu which doesn't contain macros it wouldn't start macros of another drop-down menu? Thank you for the help! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deactivate a macro when used and reactivate again | Excel Discussion (Misc queries) | |||
| activate/deactivate macro depending on who's the user | Excel Discussion (Misc queries) | |||
| How do you deactivate cells in Excel? | Excel Discussion (Misc queries) | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| activate/deactivate button with macro at given condition | Excel Programming | |||
Linear Mode
