N
Nap
Hi everyone
It seems my previous attempt at asking this question has cause
confusion
I am using personal.xls to store macros, like most people
One of the macros I have, checks any loaded workbook for certai
information (file name) and if there is a match, makes some automati
entries in that loaded workbook
When I open a file, it is usually by double clicking on a spreadshee
in Windows Explorer. This means that when Excel opens, it first load
*personal.xls*, raises the event Window_Open, and then continues t
open the *second* workbook (the one I double clicked on)
Since the second does not contain any macros, there is no Window_Ope
handler to execute
My problem is
1) I do not want any macros in the *second* workboo
2) I want the Window_Open handler in *personal.xls* to be run each tim
I load a workbook using the double click method
Cheers
Nap
PS.. Sorry about the double post, don't know how that happened. I
seems to be an empty thread
It seems my previous attempt at asking this question has cause
confusion
I am using personal.xls to store macros, like most people
One of the macros I have, checks any loaded workbook for certai
information (file name) and if there is a match, makes some automati
entries in that loaded workbook
When I open a file, it is usually by double clicking on a spreadshee
in Windows Explorer. This means that when Excel opens, it first load
*personal.xls*, raises the event Window_Open, and then continues t
open the *second* workbook (the one I double clicked on)
Since the second does not contain any macros, there is no Window_Ope
handler to execute
My problem is
1) I do not want any macros in the *second* workboo
2) I want the Window_Open handler in *personal.xls* to be run each tim
I load a workbook using the double click method
Cheers
Nap
PS.. Sorry about the double post, don't know how that happened. I
seems to be an empty thread