Link to home
Start Free TrialLog in
Avatar of jnash67
jnash67

asked on

Excel VBA - Once a commandbar is created as menbar, is there a way to set it back to toolbar and vice versa

I am adding a custom menu bar as follows:

   Application.CommandBars.Add(name:="Some Bar", position:=1, MenuBar:=True, Temporary:=True)

 Is there a way to switch the MenuBar setting to false and then later to true again?

(fyi, this is a follow up to question 23113848 that I just closed)
ASKER CERTIFIED SOLUTION
Avatar of jeverist
jeverist
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jnash67
jnash67

ASKER

Thanks.  I used both ideas.