Turn Off Automatic Calculations for Single Worksheet or Workbook, NOT ALL WORKBOOKS

[squirl1899]

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:

Please Login or Register  to view this content.

Am I entering it in the wrong place, is it the wrong code, am I just missing something or all of the above?

[JBeaucaire]

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.

[squirl1899]

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.

[JBeaucaire]

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.

[squirl1899]

Worked perfectly, thank you so much for the help!!!