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)
jnash67Asked:
Who is Participating?
 
jeveristConnect With a Mentor 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
0
 
Rory ArchibaldConnect With a Mentor 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.
0
 
jnash67Author Commented:
Thanks.  I used both ideas.
0
All Courses

From novice to tech pro — start learning today.