Menus on a User Form

  • Thread starter Thread starter Brian Stigler
  • Start date Start date
B

Brian Stigler

Can you put menus on a user form? I'm guessing no... but just wondering if
anyone has come up with a slick way to accomplish something like this.

Thanks
 
Brian,
You might enjoy playing with this that hides the active
menu bar and replaces it with a temporary menu bar that's
docked along the right side of the application window and
protected from the user:

Set oldMbar = CommandBars.ActiveMenuBar
Set newMbar = CommandBars.Add _
(Name:="newMenubar", Position:=msoBarRight, _
MenuBar:=True, temporary:=True)
With newMbar
.Visible = True
.Protection = msoBarNoMove
End With
 
Back
Top