Menus on a User Form

[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

 

[Mick]

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