Worksheet enable calculation

[Guest]

Hello,

I would like to know how I can disable the enablecalculation function of
each worksheet in my workbook?

I go and change the setting to false, but when I reopen the xls it is always
reset to true. I need it to always be false for this one xls but enabled for
all others.

Thanks,

Daniel

 

[Myrna Larson]

You could use an event macro, Workbook_Open, in the ThisWorkbook module, that
changes the setting for each sheet.

 

[Tom Ogilvy]

Set it in the workbook_Open event and then manage it with workbook_activate
and workbook_deactivate

http://www.cpearson.com/excel/events.htm
Chip Pearson's page on events.