Calculation Setting to Manual

[modytrane]

I have a large XL workbook that takes 12 to 15 seconds to calculate.
It resides on the network, so everyone can access it and add data as required. I keep it on manual for calcualtion, so people can enter all the data and at the end hit F9 to calculate.
The problem is, the setting gets changed to automatic and its annoying to other people, when they have to wait after every entry. I don't know what's changing the setting.
Is there a VBA code or Macro that can make the workbook default to Manual when you open the workbook. This way it will always open with Manual setting.

Thanks,
modytrane

[royUK]

This will do that

Please Login or Register  to view this content.

However, I would investigate why the workbook is taking so long to calculate.

[modytrane]

Thanks,
It works.
The calucations take time, because the workbook has one sheet as a master database with over 400 rows and 20 columns of data.
There are 18 other sheets that draw information from this database to generate a variety of summary reports and Graphs. Some of the summary reports have error checking formulas that look for missing data and alert the user if they didn't fill in certain information on the database sheet.
With your code it defaults to Manual calculation and its only a one time wait at the end, after all the changes have been made.

Thanks again,
modytrane.