Menus on a User Form
 

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

Menus on a User Form
 

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


-----Original Message-----
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


.