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!

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" <(E-Mail Removed)> wrote in message
news:6D874CDB-6DA5-404F-A436-(E-Mail Removed)...
>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!

hi
disable events.

Application.EnableEvents = False
Workbooks.Open Filename:= _
"C:\my\file\path\FileWithOnOpenMacro.xls"
Application.EnableEvents = True

this should disable the on open macro.
regards
FSt1

"John" wrote:

> 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!