MACRO TO SET THE AUTOMATIC CALCULATION

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for a workbook macro that will make sure the workbook is always
opened with automatic calculation option set.
Thanks.
 
In Workbook code enter:

Private Sub Workbook_Open()
Application.Calculation = xlAutomatic
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Excel global setting for all workbooks? Calculation Automatic 1
Excel 2003 automatic calculation all worksheets except one 3
Reset workbook back to Auto Calculate 8
F9 Manual Recalculate only for one workbook 7
"Calculate" appears in staus bar 2
Auto Import From Other Doc 5
"Automatic Calculation" option intermittent 2

Back
Top