I have a workbook with multiple worksheets and I want this workbook, and all of the worksheets to be set to "Manual Calculations" but don't want to turn off "Automatic Calculations" for ALL of Excel.
I have entered this code in each worksheet and added it as a Module to the Workbook but it isn't working:
Am I entering it in the wrong place, is it the wrong code, am I just missing something or all of the above?
Please Login or Register to view this content.
That code only goes into the individual sheet modules, not inserted code modules.
Also, you will want to create Workbook_BeforeClose() event in the ThisWorkbook module that sets things back to "automatic" as well in case they close that workbook.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you for your reply.
2 Things:
1) When I enter it into the individual sheets it still automatically calculates. I have saved the workbook, closed it, reopened it and it still automatically calculates so the code isn't working.
2) I don't know how to create an event, I just copied this code from the forum.
Right now your macros look backward to me. It seems you would want Excel to be in Automatic mode EXCEPT when you are on specific sheets, your current macros seem to be doing the opposite, so try switching them around first.
Another way is to create a SINGLE macro in the ThisWorkbook module to handle this as you change sheets within the workbook. Also a couple of other workbook events to make sure calculation is on if you switch to another workbook"
All of this in the ThisWorkbook module:
Please Login or Register to view this content.
Worked perfectly, thank you so much for the help!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks