You could either put it in your PERSONAL MACRO WORKBOOK or develop it into
an addin...

How to create a macro *template* to store macros to be available in all
workbooks:
http://www.personal-computer-tutor.com/personalxls.htm

Microsoft Excel VBA Macros. How to Create an Excel Add-in For Them
http://www.ozgrid.com/VBA/excel-add-in-create.htm

"Mark Ojie" <Mark wrote in message
...
I am trying to use a group of user forms in several different woorkbooks
that
will be linked.
I want the user forms accessible from any of the workbooks when certain
command buttons are clicked.
Can anyone please help on this.
Thanks