I have a few spreadsheets that have large macros that create high-level reports in a small window of time by people other than myself. It is imperative that the calculation be set to automatic before they are run to avoid errors (and follow-up questions to me). I inputted the following macro code and tested it. I set the calculation to manual (via Formulas=>Calculation Options), saved the file, then reopened it. The calculation stayed on the setting, Manual. ...
Any idea why it won't execute when the file is opened? I have the Trust Center setting's radio-button on Enable all macros.
[vba]Private Sub Workbook_Open()
With Application
.Calculation = xlAutomatic
End With
End Sub
[/vba]
Reply With Quote
