open up an excel program with an auto open macro
Hi John,
If you open Workbook B with code from Workbook A, the Auto_Open procedure in
WorkbookB will not run unless you explicitly stipulate that it should.
Conversely, Workbook B's Workbook_Open sub would run.
---
Regards,
Norman
wrote in message
oups.com...
Hi,
I have a program that i am working on, with this program i wish to open
up another workbook, and copy some data from it. The problem is that
the workbook i want to access has an Auto open program that loads a
userform as soon as its open. Is there a way that I can stop this
macro from working using code from my new program when my new program
opens up the other workbook.
regards
John
|