Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |