LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Disable Calculation of selected worksheets toggle

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
disable multiple toggle buttons Shoney Excel Programming 1 January 15th 08 08:59 PM
manual/auto calculation toggle button scott[_12_] Excel Programming 1 December 4th 07 04:56 PM
Calculation toggle JP[_3_] Excel Programming 2 October 16th 07 06:35 PM
Toggle Calculation Status Paige Excel Programming 5 February 15th 07 07:27 PM
Toggle calculation FJDx Excel Programming 3 July 19th 04 01:10 AM


All times are GMT +1. The time now is 10:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"