Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control Worksheet_SheetChange Events
I have a class that I created which automatically updates the cell
format based upon the input. The problem I have is that I have several add-ins that are used to pull data into excel so when I run those my sheet_change event runs as well and slows down the data download considerable. I am trying to figure out how to control it so that if these other add-ins run, then my cell update event won't run until it is done. Any ideas? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control Worksheet_SheetChange Events
Hi Legacy,
Can you not disable, and subsequently re-enable, events: [...] With Application .EnableEvents = False 'Perform your actions .EnableEvents = True End With [...] --- Regards. Norman wrote in message ... I have a class that I created which automatically updates the cell format based upon the input. The problem I have is that I have several add-ins that are used to pull data into excel so when I run those my sheet_change event runs as well and slows down the data download considerable. I am trying to figure out how to control it so that if these other add-ins run, then my cell update event won't run until it is done. Any ideas? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control Worksheet_SheetChange Events
I might not be explaining this correctly. The other functions are
being run from 3rd party add-ins or dlls so I don't have access to them. I only have access to the format cell event that I created. If I disable events then mine won't run at all. I need to somehow catch the fact that one of these other items is being run and then I can turn off and turn on events. I hope this explains it better. Also, i may be misunderstanding your solution so let me know if that is the case... On May 1, 12:37 pm, "Norman Jones" wrote: Hi Legacy, Can you not disable, and subsequently re-enable, events: [...] With Application .EnableEvents = False 'Perform your actions .EnableEvents = True End With [...] --- Regards. Norman wrote in message ... I have a class that I created which automatically updates the cell format based upon the input. The problem I have is that I have several add-ins that are used to pull data into excel so when I run those my sheet_change event runs as well and slows down the data download considerable. I am trying to figure out how to control it so that if these other add-ins run, then my cell update event won't run until it is done. Any ideas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with listbox control events | Excel Programming | |||
ActiveX Control Events dropped | lost | blocked - Excel / VBA | Excel Programming | |||
How do I get events from a "Split Button Popup" control? | Excel Programming | |||
Events for Controls in a Multipage Control | Excel Programming | |||
Run Time control events | Excel Programming |