How to turn a user form into an add-in
 

I have created a userform that is a crucial part of a macro that I want
to use many times in many workbooks. When I create a special toolbar
with a button assigned to the macro, excel doesn't know to bring along
the userform and I get an error message. How do I install the userform
as an add-in and connect it to my macro? Thanks. -Abe

How to turn a user form into an add-in
 

Abe, To make your userform an add-in make sure you need to set the
workbook add-in property to True. To do this, launch VBEditor. Press
F4 to open the Properties box and then choose Thisworkbook for the
workbook the Userform is in. Find IsAddin and set it to true.

Then put your menu building code in that workbook to where it creates
the menu when the add-in is launched (auto_open) and install the add-in
in Excel.

If you dont want to build the menu you could setup a hotkey to launch
the Userform.


--
jtp
------------------------------------------------------------------------
jtp's Profile: http://www.excelforum.com/member.php...o&userid=21132
View this thread: http://www.excelforum.com/showthread...hreadid=562707

How to turn a user form into an add-in
 

Works great! Thanks.