We help IT Professionals succeed at work.

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)
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Hi jnash67,

>  Is there a way to switch the MenuBar setting

No.  You would hace to delete it and recreate it as a normal CommandBar like this:

Dim CustomBar As Object
Const CustomBarName = "Some Bar"

On Error Resume Next
Application.CommandBars(CustomBarName).Delete
On Error GoTo 0

Set CustomBar = Application.CommandBars.Add(Name:=CustomBarName, Position:=msoBarTop)

Jim
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011
Commented:
Additionally, if you add a boolean parameter to the routine that creates the bar, you can optionally create it as a menubar or not, which will make it easier if you need to switch between the two.

Author

Commented:
Thanks.  I used both ideas.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.