Check if workbook is open...
put your open code in a standard module called Auto_Open. it will only run when
the workbook is opened manually not via code.
if you have your code in a workbook_open module, it will fire whether the
workbook is opened manually or via code.
--
Gary
"John" wrote in message
...
I have a workbook that runs a macro when it open. I have a second workbook
that needs to open the first workbook and import data. How do I prevent the
opening macro from running when the other workbook opens it?
Using Excel 2003
Thanks in advance!
|