Personal.xls Macros?
To call a macro in another workbook, you would use
Application.Run "Personal.xls!MyMacro",arg1, arg2
as an example.
--
Regards,
Tom Ogilvy
"Chris" wrote in message
...
I am trying put a macro into the personal.xls file so
that it loads whenever I open a new workbook. I have
made all of the subroutines & functions public, but it
doesn't seem to be working - are there any tricks to make
the new workbook recognize the macro. Thanks in advance
for the help.
Chris.
|