Shutting off calculation in certain areas

**letitbleed** · 08-26-2009, 02:11 PM

Does anyone know if you can shut off the automatic calculation of a particluar worksheet or better yet, certain areas of a workbook, leaving the remainder of the workbook as Automatic?

For example, a workbook with Sheets 1,2,3 and 4. Can Excel 2007 be set for automatic calculations on the entire workbook except for Sheet3?

Thanks.

**shg** · 08-26-2009, 03:23 PM

Welcome to the forum.

I don't think you can do that via the UI, but you can in VBA:

Worksheets(1).EnableCalculation = False

**letitbleed** · 08-26-2009, 03:58 PM

Thanks for the welcome.

My problem is I am not familiar with the Visual basic end of excel. Can I just insert that command by right clicking that sheet and selecting "View Code" and inserting there?

Thanks again.

**shg** · 08-26-2009, 04:04 PM

You can put these in a code module:

Sub CalcOff()
    Worksheets(3).EnableCalculation = False
End Sub

Sub CalcOn()
    Worksheets(3).EnableCalculation = True
End Sub

Adding a Macro to a Code Module
1. Copy the code from the post
2. Press Alt+F11 to open the Visual Basic Editor (VBE)
3. From the menu bar in the VBE window, do Insert > Module
4. Paste the code in the window that opens
5. Close the VBE to return to Excel

To run one or the other, do Alt+F8