Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro ignors module code
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove Protected Macro Code from Excel Module | Excel Discussion (Misc queries) | |||
code to delete module / macro in another file | Excel Discussion (Misc queries) | |||
Macro ignors module code | Excel Programming | |||
Macro ignors module code | Excel Programming | |||
Macro ignors module code | Excel Programming |