Macro ignors module code
Bob, Thanks for the help - I got it working.
-----Original Message-----
Phil,
Sorry about last post, my laptop touchpad is causing me
much grief.
I was suggesting using Workbook_Open event code. Just put
the same code into
the Workbook_Open event. This goes in the ThisWorkbook
code module.
--
HTH
Bob Phillips
"Phil Hageman" wrote in message
...
I have the following macro code in the Personal.xls
workbook to open a workbook:
Sub OpenBSC()
Workbooks.Open ("W:\Housing\Housing BSC for 2004.xls")
End Sub
However, the sub ignores an AutoOpen() sub in the target
workbook's Module1. How do I make the macro run the
Module1 AutoOpen() in the target workbook?
Thanks, Phil
.
|