Hi
why not set
application.Calculation
accordingly (and store the old stte if you want)

--
Regards
Frank Kabel
Frankfurt, Germany

"Ant" schrieb im Newsbeitrag
m...
I have an xla that needs to open a workbook when it loads, because of
a previously reported problem: "Excel 2003 graphics are invisible
after loading xla".

The problem with this is that Excel is no longer in its correct
start-up state. In particular, the calculation settings will not then
be picked up by the first workbook that a user opens.

Does anyone know how to UNSET the calculation settings, so that Excel
thinks they haven't been chosen yet?

Also, does anyone know of any descriptions of how Excel initialises
itself?