Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
manual/auto calculation toggle button
I have an addin for a toolbar to toggle calculation on and off.
Everything works fine. I am tracking the current status by checking everytime the TrackEvent_SheetChange fires. I do have people who have written macros that turn off calculation and never set it back, or they change it manually. I want this toggle button to always reflect the current state of auto or manual, so if something has changed I want the button to auto-update itself. Everything works, I only wonder if there is another approach to check the status, than firing on the TrackEvent_SheetChange. Thanks, Scott Denton |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
manual/auto calculation toggle button
There is no fool-proof way to detect this change, but I did it by setting up
a class that monitors the selection of Tools | Options command, then use the OnTime event to update the status of calculation mode after some period of time (I actually fire two OnTime commands, one at 5 sec and one at 30 sec for those that take more time to find/change the setting or get distracted). I don't know how you would detect a change from another macro unless you continually ran an OnTime routine. "scott" wrote in message ... I have an addin for a toolbar to toggle calculation on and off. Everything works fine. I am tracking the current status by checking everytime the TrackEvent_SheetChange fires. I do have people who have written macros that turn off calculation and never set it back, or they change it manually. I want this toggle button to always reflect the current state of auto or manual, so if something has changed I want the button to auto-update itself. Everything works, I only wonder if there is another approach to check the status, than firing on the TrackEvent_SheetChange. Thanks, Scott Denton |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto/Manual Calculation using *.slk files | New Users to Excel | |||
Auto Filter Toolbar Button Does not Toggle | Excel Discussion (Misc queries) | |||
default manual calculation instead of auto in options excel 2003 | Excel Discussion (Misc queries) | |||
Adding .xla button for Toggle Calculation Button | Excel Programming | |||
Excel Opens with Manual Calculation option on instead of Auto | Excel Programming |