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

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

On Tue, 19 Oct 2004 13:31:04 -0700, Daniel
wrote:

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

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.

--
Regards,
Tom Ogilvy

"Daniel" wrote in message
...
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