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