| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Detecting Calc On or Off
I have 2 radio buttons - one marked "Calc On" and one marked "Calc Off".
The user can turn auto calc on or off. There are other macros in the spreadsheet - and I also turn calc off during those macros and then turn it back on. What I want is to be able to detect what the current setting is and then set it to that at the end of macro execution. So if Calc is "OFF" then at the end of the macro I want to leave it off. Any advice is appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calc = Manual & Do Not Calc b/4 SAVE | Excel Discussion (Misc queries) | |||
| My calc key on Excel changes box to "Text" Box and doesn't calc ? | Charts and Charting in Excel | |||
| auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
| Detecting absentees | Excel Discussion (Misc queries) | |||
| Detecting a color | Excel Worksheet Functions | |||
Threaded Mode
