Hi -- can someone definitively answer true or false? Application.EnableEvents=False is not effective when dealing with changes effected from within Range.Validation?
I am manipulating lists within the Validation object, with EnableEvents set to False (repeatedly); nevertheless when I make the changes to the criteria it triggers changes attached to the WkshtChange code.
I need to bring all triggersto a halt while I make changes via code... any thoughts?
Thanks --
Feckless in Seattle
Could you post your code showing what you are doingIf you are using forms then the answer is no. From within a module it should. If you could post your code that triggers worksheet_change event and confirm that code is within a module and not a formwhen dealing with changes effected from within Range.Validation
Hope this helps.
Anthony
Pack my box with five dozen liquor jugs
PS: Remember to mark your questions as Solved once you are satisfied. Please rate the answer(s) by selecting the Star in the lower left next to the Triangle. It is appreciated?
I appreciate the response. The answer is I am not using a form, only setting validation rules within several cells on a sheet, triggered by a change in upline cells. The result is like a bullet ricocheting around the worksheet, changing cell values based on newly updated validation rules (after I have set Application.EnableEvents=False.)
Let me see if I can get some clean code in here... it is spread out amongst several Subs...
Your worksheet_change event should be denied when having "Appliciation.enableEvents = False"
Any routines that contain such event trigger do not apply when you run EnableEvents = False.
The effect also works works trough other workbooks. and after reopening excel.
(When i am not sure i always make small excamples for my self to test them out what they do)
An event is raised when the action that initiates the event occurs and the application automatically signals to all the components connected to object generating the event. The problem can be especially with worksheet_selectionChange event in that multiple events can be raised BEFORE you can turn off events (with Application.EnableEvents = False). Turning off events prevents further events downstream being raised not preventing upstream events that have already been raised. There is one other way of preventing a runaway loop of events by setting a Public Variable and testing that variable (usually a boolean) in the various events and use this to prevent events firing like a "bullet ricocheting around the worksheet"
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks