Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User form | Excel Discussion (Misc queries) | |||
User Form | Excel Discussion (Misc queries) | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
User Form | Excel Discussion (Misc queries) | |||
Drop-Down Menus in Data Entry Form? | Excel Discussion (Misc queries) |