MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Change Configuration On Exit

Posted by Don Coffman on February 19, 2001 3:52 AM

I have a spreadsheet that requires operation in the "manual recalc mode". I set this in an open macro, but Excel remains in this mode after exiting this sheet. How can I return to the normal auto recalc mode upon exiting this sheet?

Posted by David Hawley on February 19, 2001 4:05 AM

Don, Right click on the sheet, select "View Code" and paste in this code:

Private Sub Worksheet_Deactivate()
Application.Calculation = xlCalculationAutomatic
End Sub

....and yes!, you can have Excel go to Manual calculation when this sheet is selected, use this:

Private Sub Worksheet_Activate()
Application.Calculation = xlCalculationManual
End Sub

Good luck


OzGrid Business Applications