Custom Menu
First try:
Private Sub UserForm_activate()
MsgBox ("Hi Mike")
End Sub
just to make sure the button is connected to the handling sub.
Then, with your original code, make su
PRProc
has been declared in a nice Public fashion.
--
Gary''s Student - gsnu200748
"Mike H." wrote:
I have this code on a custom menu option:
With CustomMenu.Controls.Add(Type:=msoControlButton)
.Caption = "Process This Labor Summary"
.OnAction = UserForm2.Show
End With
And this code on activation:
Private Sub UserForm_activate()
Call PRProc
End Sub
But this does not work. How do I have a menu option load a form which then
calls a process?
|