Place the following line of code in the "Sub Workbook_Open
()" procedure.

Application.Calculation = xlManual

Michael

-----Original Message-----
I have a rather large workbook (85 meg) that I've built
for a client.
It is necessary that automatic calculation be turned OFF
when using
this tool otherwise a normal machine will lock up. Is
there a macro or
a way to default manual calculation when this workbook
is opened?

You advice is appreciated.


---
Message posted from http://www.ExcelForum.com/

.