Check out this discussion where Excel MVP Nick Hodges gets in on the act, and
between the code provided, and the original requester determining that it can
be done by opening a second instance of Excel and shutting down macro
execution in it, he could get the job done:
http://www.ureader.com/message/1126616.aspx


"Pickle" wrote:

can you write VB code in excel to Disable Macros when opening another excel
file