If you are opening the file via VBA code, the Auto_Open macro won't run, but
the Workbook_Open event will run. You can disable all events (such as
BeforeClose) with code like
Application.EnableEvents = False
' do something
Application.EnableEvents = True
--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
"OlieH" wrote in message
...
Chip thanks for the reply. I am opening the workbook from within a macro
in
a different workbook. I did get the workbook to open without executing
the
Auto_Open. Now my problem is that in the "opened workbook" I have a
before_close event that is triggered, when I tried to close the 2nd
workbook.
Any way to prevent the before_close macro from running from within the
first
opened workbook?
"Chip Pearson" wrote:
Olie,
Hold down the SHIFT key when you open the file and the code won't run.
--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
"OlieH" wrote in message
...
I wish to open a workbook that has Auto_Open installed. I merely want
to
extract information from a specific cell. My proglem is that the
workbook
when opend will run Auto Open. Is there a way to prevent the Auto_Open
macro
from execuiting?
I appreciate the help.
Olie