You're welcome Gary.

One thing to note if you choose to use a toolbar rather than a menu is
that depending on the settings you specify the user could close the
toolbar meaning that they have no way to activate the form aside from
closing and reopening the workbook.

Regards
Rowan

Gary Keramidas wrote:
thanks rowan. i guess the code did work, when i went to customize, all the
commandbars i created were listed there, they just weren't visible. the code
you pointed me to seems to work just fine. i don't need 3 buttons, i'll fix
that, but i got my form to fire when i click a button.

this way they can't click a button on the toolbar with the wrong workbook
open an generate an error. it will only be available when the workbooks with
this code attached.

thanks again.