View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.