ExcelBanter - MACRO TO SET THE AUTOMATIC CALCULATION

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - MACRO TO SET THE AUTOMATIC CALCULATION (https://www.excelbanter.com/excel-discussion-misc-queries/118891-macro-set-automatic-calculation.html)

MACRO TO SET THE AUTOMATIC CALCULATION

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

Gary''s Student

MACRO TO SET THE AUTOMATIC CALCULATION

In Workbook code enter:

Private Sub Workbook_Open()
Application.Calculation = xlAutomatic
End Sub
--
Gary's Student

"OB" wrote:

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

MACRO TO SET THE AUTOMATIC CALCULATION

Thanks!

"Gary''s Student" wrote:

In Workbook code enter:

Private Sub Workbook_Open()
Application.Calculation = xlAutomatic
End Sub
--
Gary's Student

"OB" wrote:

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

All times are GMT +1. The time now is 08:52 PM.