Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I have a Change Event for a worksheet, where 2 cells on this worksheet are checked, and some actions are taken, whenever some of them changes. By certain conditions, one of actions will be changing the entry in one of checked cells - which will fire the same Change event again, etc. Is there a way to 'switch the Change Event firing off' temporarily. I mean, that when the condition for changing this cell value is met, some code row has to switch executing of further Change events off, after that the change to cell is made, then further change events are turned on again, and then rest of code in current Change event is processed. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel2000 worksheet Change event doesn't work in Excel2003 or higher | Excel Programming | |||
How do I change a Worksheet_change event to a beforesave event? | Excel Programming | |||
Worksheet_change event. | Excel Programming | |||
Excel2000 VBA If-Then/Loop Failures | Excel Programming | |||
Worksheet_Change Event | Excel Programming |