Iam using an Excel workbook from a third party that includes lots of macros
(all of which are protected). When I open the workbook, it recalculates
itself (which takes rather a long time). normally this isn't a problem,
however, I have written some VB code to automate some processes that include
reading data from the workbook, and setting a single value(cell) on certain
worksheets. This value is not involved in any calculations used within the
workbook.

Is there a way to prevent the automatic recalculation so that I can speed up
my automated process (there could be hundreds of instances of this workbook
being opened, read from, updated (one cell remember) and saved in a serial
fashion.

I did once find a registry setting that did what I wanted, but I now cannot
find the reference to it!

Thanks for looking

John
--
UK John