View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
OlieH OlieH is offline
external usenet poster
 
Posts: 39
Default with a macro open a workbook without the Auto_Open running

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