Userform button?

[Ithaca]

I'm trying to create a custom button to call a macro that runs via userform
but have been unsuccessful. I can create a button to call the related macro
but I need the actual userform to be called. is there a way to do this?

Also, is there a way to distribute this button to others that may need it?
Or will I have to create it on each computer individually?

Thanks in advance for any help!

-Ithaca

 

[JCNZ]

Hi Ithaca:

Get the custom button to call a macro to load the form:

Sub Loader()
Load Userform1
Userform1.Show
End Sub

If you store the toolbar with the button in a template, then everyone who
accesses the template will see the button.

Cheers.