VBA/Excel 2010: Commandbars

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
21,800
Office Version
  1. 365
Platform
  1. Windows
For some reason, the 'Name' property for three commandbars return blanks/null strings. In an effort to try and determine whether this should in fact be the case, will someone be kind enough to enter the following in the Immediate Window to see whether a blank/null string is returned?

? application.CommandBars(127).Name

? application.CommandBars(149).Name

? application.CommandBars(150).Name

Thanks!
 
Last edited:

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
? application.CommandBars(127).Name
Property Editor

? application.CommandBars(149).Name
Blank

? application.CommandBars(150).Name
Blank
 
Upvote 0
Hello Domenic

These are the results I get.

? application.CommandBars(127).Name
Task Pane
? application.CommandBars(149).Name
Envelope
? application.CommandBars(150).Name
Online Meeting

EDIT: but when I list them, 128, 151, and 152, are blank.
 
Last edited:
Upvote 0
Here's the output from my Excel 2010.

? application.CommandBars(127).Name

? application.CommandBars(149).Name
Envelope
? application.CommandBars(150).Name
Online Meeting
 
Upvote 0
Kyle, Brian, and delaneyjm,

Thank you very much for you help. I really appreciate it.

So I can see from the results that it's not unusual for a commandbar to have a blank name. I don't understand why, though. :-) I do have each of the specified commandbars (Property Editor, Task Pane, etc.). However, they're found at different indexes.

Thanks again, everyone!
 
Upvote 0

Forum statistics

Threads
1,224,599
Messages
6,179,827
Members
452,946
Latest member
JoseDavid

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