| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disabling WORKSHEET_CHANGE event
Is there a way to temporarily disable a sub worksheet_change()? I was
thinking of something along the lines of.... application.wokrsheet_change = false and then run a macro that makes a bunch of changes to my sheet and then make it true again? I know this method does not work but I was hoping there is something along the lines of this out there. thanks, Jase |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Disabling WORKSHEET_CHANGE event
application.enableevents = false
'do the work application.enableevents = true But it disables all events--not just the worksheet_change event. Jase wrote: Is there a way to temporarily disable a sub worksheet_change()? I was thinking of something along the lines of.... application.wokrsheet_change = false and then run a macro that makes a bunch of changes to my sheet and then make it true again? I know this method does not work but I was hoping there is something along the lines of this out there. thanks, Jase -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet_change event handler error | Excel Discussion (Misc queries) | |||
| Worksheet_Change | Excel Worksheet Functions | |||
| Controling the Worksheet_Change Event? | Excel Discussion (Misc queries) | |||
| How do I make a "Worksheet_Change event" to show any changes to cells? | Excel Worksheet Functions | |||
| In the worksheet_change event, how do I determine what occured? | Excel Worksheet Functions | |||
Linear Mode
