Thread: Custom Menu
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default Custom Menu

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?