View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default with a macro open a workbook without the Auto_Open running

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