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

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

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

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