Excel command bar list
 

Hi,
I'm looking for a list of all the available commandbars in Excel 2007. For
example CommandBars("Cell") is one of them.
Thank you

Excel command bar list
 

Sub AAA()
Dim N As Long
With Application.CommandBars
For N = 1 To .Count
Cells(N, 1).Value = .Item(N).Name
Next N
End With
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Synapse" wrote in message
...
Hi,
I'm looking for a list of all the available commandbars in Excel 2007. For
example CommandBars("Cell") is one of them.
Thank you

Excel command bar list
 

Thank you. I've printed the list. But is there a way to have a description of
each ? Do you know the one for the the cell edit mode context menu ?

"Chip Pearson" wrote:

Sub AAA()
Dim N As Long
With Application.CommandBars
For N = 1 To .Count
Cells(N, 1).Value = .Item(N).Name
Next N
End With
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Synapse" wrote in message
...
Hi,
I'm looking for a list of all the available commandbars in Excel 2007. For
example CommandBars("Cell") is one of them.
Thank you

Excel command bar list
 

Never mind, I've found it. It was "Formula Bar", a very implicit name ^^

"Synapse" wrote:

Thank you. I've printed the list. But is there a way to have a description of
each ? Do you know the one for the the cell edit mode context menu ?

"Chip Pearson" wrote:

Sub AAA()
Dim N As Long
With Application.CommandBars
For N = 1 To .Count
Cells(N, 1).Value = .Item(N).Name
Next N
End With
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Synapse" wrote in message
...
Hi,
I'm looking for a list of all the available commandbars in Excel 2007. For
example CommandBars("Cell") is one of them.
Thank you