Custom Command Bars won't stay on same row in Excel 2003

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 Auto_Open 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 cb.Name = COMMAND_BAR_NAME_JS Then​
cb.Visible = True​
found = True​
Exit For​
End If​
Next
If 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
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Forum statistics

Threads
1,224,561
Messages
6,179,521
Members
452,923
Latest member
JackiG

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top