Where is Commandbars(1).Controls(8)

Emily · Mar 30th, 2004, 04:13 PM

Below code can list 10 items but I can only find 9 on the menu bar, where is the eighth one, i.e. between "Data(D)" and "Window(W)"

Thanks

Code:

With Application.CommandBars(1)
   i = 1
   For Each c In .Controls
      Cells(i, 1) = c.Caption
      Cells(i, 2) = c.ID
      i = i + 1
    Next
End With

Whisperer14 · Mar 30th, 2004, 04:45 PM

I am beginning to think that it is a redundant control, it is mentioned around xl97 time but is certainly not active in 2002, even using Alt+c has no effect.

It is also mentioned as the 8th control on the chart menu but again does not appear to be active in any way.

Mar 30th, 2004, 04:13 PM	#1
Emily Join Date: Aug 2002 Location: Hong Kong, China Posts: 304	Where is Commandbars(1).Controls(8) Below code can list 10 items but I can only find 9 on the menu bar, where is the eighth one, i.e. between "Data(D)" and "Window(W)" Thanks Code: With Application.CommandBars(1) i = 1 For Each c In .Controls Cells(i, 1) = c.Caption Cells(i, 2) = c.ID i = i + 1 Next End With

Mar 30th, 2004, 04:45 PM	#2
Whisperer14 Join Date: Nov 2002 Location: Cornwall UK Posts: 589	I am beginning to think that it is a redundant control, it is mentioned around xl97 time but is certainly not active in 2002, even using Alt+c has no effect. It is also mentioned as the 8th control on the chart menu but again does not appear to be active in any way. __________________ Never too old to learn...

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode