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 - 20 Oct 2006 06:56 GMT
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.
> 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
[quoted text clipped - 6 lines]
>
> -Ithaca