Assign Macro to a Command Button

[smil3y]

I have a personal.xls file which is contained in the XLstart folder. This file contains all my commonly used macros. Until now I have only run the macros via the Tools/Macro/run selection.

I have inserted a button on a spreadsheet (Equipment.xls)and need to assign a macro that is in personal.xls. My code is:

Private Sub cmdPopulate_Click()
Copyitmotor
End Sub

I get a function or sub not defined error because the macro is in the personal.xls file.

Can someone please advise the format for correctly assigning the macro.

Thanks

 

[PHV]

You may try this:
Application.Run "personal.xls!Copyitmotor"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[smil3y]

Worked - Many thanks