I suspect I am running into a problem of either not understanding the limitations of Application.EnableEvents and/or a conflict with placing some of my code in the worksheet's code page instead of a module.
With the following, if I don't have EnableEvents set to false, the writes to the same page trigger the change event (which I am using each time the target cell is changed to update a group of displayed values).
Unfortunately using Application.EnableEvents = False prohibits the lines![]()
Please Login or Register to view this content.
from functioning. I thought that Application.EnableEvents = False would only prevent Events from running, not prevent code from posting values!![]()
Please Login or Register to view this content.
I must be doing something fundamentally wrong here - Thoughts?
Thank-you!
Bookmarks