Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have been reading through prior posts for some code to disable calculation
process on a select sheet, so far no luck. So I have to ask for help on this one. I have a large worksheet that produces various reports from common data which really slows the calculation to 3 min. I would love to be able to disable calculation on some worksheets altogether when I dont need them and reenable when necessary. Thus, it would really be nice to add the following controls code for a toggle button to turn calculation off for a specific worksheet display the status whether the worksheet is disabled or enabled I was hoping to create a "Control" worksheet tab that would list all tabs with toggle device (button) next to it and then worksheet status somewhere next to the worksheet name. This is different then what I see others have posted on auto vs manual calc macros. I am not sure if what i need is possible but so far this community has always led me to a solution. If there is solution can someone please provide some example to code this for one or two worksheets please? I am a novice at this but can generally follow the logic but weak on syntax. Thank you as always, Floss |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
disable multiple toggle buttons | Excel Programming | |||
manual/auto calculation toggle button | Excel Programming | |||
Calculation toggle | Excel Programming | |||
Toggle Calculation Status | Excel Programming | |||
Toggle calculation | Excel Programming |