You could put the macro into your personal.xls file. Do a search on your C:
dirve for the directory XLSTART (varies with different versions of offfice)
and create an Excel file called personal.xls. Add macro to this workbook.
then everytime you open excel this macro can be called.

"Roger Withnell" wrote:

Thanks. Worked a treat.

The macro is associated with a specific spreadsheet. Is it possible to save
the macro in a separate file so that it can be used with any designated
spreadsheet.

Thanking you in anticipation.

"papou" wrote:

Hi Roger

Create a Sub in a standard module and then call your form from this sub.
eg:
Sub LaunchMyForm()
Load USerForm1
UserForm1.Show
End Sub

HTH
Cordially
Pascal

"Roger Withnell" a écrit dans le
message de news: ...
I have built a macro in VB for a particular spreadsheet, opening VB from
within Excel. The macro is in the Forms folder and double clicking the
button (that starts the macro) on the form opens the code window.

I can now run the macro successfully within the VB window, using the Run
Sub/Userform button. How do I initiate this macro from the spreadsheet
ToolsMacroMacros window? It is not listed there currently.

I would like to email this macro to my partner to use. Does it have to be
emailed with the spreadsheet in which it was built? I would rather it
were
possible to run it with any designated spreadsheet.

Thanking you in anticipation.