User Forms availabilty to all workbooks

[Guest]

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

 

[Mark Ivey]

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

 

[Guest]

Thanks Mark,
I am abit new to the VBA programming. this application will eventually be
distributed to non networked systems does that mean i will have to install
the addin on each local system.
I am trying to stay away from the use of a pure database
Again thanks for the help

 

[Mark Ivey]

I am not sure of all your specifics, but if it needs to be portable I would
strongly recommend the addin option.

If you need help with specifics, you could post your code and there are
several that might be able to help you out.

Even better... if you have a place to upload your stuff to the web... it
would be much easier to see some real examples.

Mark Ivey