Maybe...

on error resume next
application.enableevents=false
'open other wb
application.enableevents=true
on error goto 0

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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