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

Dave

OzGrid Business Applications