Personal.xls Macros?

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

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.
 
To call a macro in another workbook, you would use

Application.Run "Personal.xls!MyMacro",arg1, arg2

as an example.
 
Tom,
Thanks for the help, but it didn't solve my problem. I
am using a command button in Excel (new workbook) to open
the macro (well VB script really) in personal.xls. Here
is the command button statement right now:

Private Sub CommandButton1_Click()
Call SFileOpen 'name of subroutine in personal.xls
End Sub

Once again any help is greatly appreciated.

Chris.
 
I gave you the answer. Call won't work unless you set a reference from the
sheet with the button to the personal.xls file which is generally not
something you want to do.


Private Sub CommandButton1_Click()
Application.Run "Personal.xls!SFileOpen" 'name of subroutine in
personal.xls
End Sub
 
Back
Top