Dannyh1
Well-known Member
- Joined
- Nov 18, 2009
- Messages
- 1,144
Hi,
I have the following code
The problem is I don't want anything to calculate when the file is opened. This code calculates the spreadsheet & then switches the calc to manual.
Is there a way around this?
Thanks
I have the following code
Code:
Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
End Sub
The problem is I don't want anything to calculate when the file is opened. This code calculates the spreadsheet & then switches the calc to manual.
Is there a way around this?
Thanks