Rolo Tomassi
New Member
- Joined
- Mar 25, 2011
- Messages
- 1
I have 3 custom Commandbars using VB in Excel 2003. They will not stay on the same row when I position them in the toolbar. I tried the simple solution of deleting the .xlb file without success. I tried using Commandbar properties like Rowindex and Position in different combinations without success. I'm thinking the coding is conflicting in the Autpen module (or its just bad code), but I'm too novice to solve it and a little tired of trying (just about the entire day at work). All three are similar, listed below. Thanks in advance for any clues.
found = False
For Each cb In Application.CommandBars
If Not found Then
found = False
For Each cb In Application.CommandBars
If cb.Name = COMMAND_BAR_NAME_JS Then
cb.Visible = True
found = True
Exit For
End If
NextIf Not found Then
Set cb = Application.CommandBars.Add(Name:=COMMAND_BAR_NAME_JS, Position:=1)
With cb
Add buttons code
.Visible = True
End With
End If