Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable events does not work
Hi,
I have several public functions in the workbook I am working with, that are activated or executed whenever I make changes in the worksheets trough VBA. Although that is not a problem, it is not a good thing as it is slowing the execution of the VBA code. My guess is that the changes of the VBA codes into the worksheets, clear cells, etc, trigger worksheets changes events. At the beginning of the VBA code I already used: application.EnableEvents=False to avoid those unnecessary calls to the public functions but it does not work. what am I missing ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Events won't Disable! | Excel Discussion (Misc queries) | |||
Disable Form Events From Being Triggered | Excel Programming | |||
disable events while macro is running | Excel Programming | |||
Disable Events | Excel Programming | |||
Disable Key Events | Excel Programming |