how to disable the Options Button in Commandbars (Excel 2003)

[heinz]

Hello,

in my program I have extra commandbars for the users and I do not want
them to use the original ones. I use already
CommandBars("ToolBar List").Enabled = False
to disable the right click on the commandbars.

Now in Excel 2003 there is an additional drop down on the right top of
the commandbar called "options for commandbar" which allowes the user
all the time to reset the menues. I clearly have to avoid this.

Please, does anyone knows a way to disable this dropdown?

Thanks a lot
Heinz

 

[heinz]

The solution can be found under (little long):

http://groups.google.com/groups?hl=...06260725.610d2c4c%40posting.google.com&rnum=2

So I allowed myself to copy the aswer from Jim:

I call code like this with a True or False argument:

''Lily pad to XL 10+ items configuration items
''Can't call directly because new property names
''would error in pre-Excel 2002 versions.
Sub CallDisableExcel10Items(OnOff As Boolean)
If Val(Application.Version) > 9 Then DisableExcel10Items OnOff
End Sub

Sub DisableExcel10Items(OnOff As Boolean)
Application.CommandBars.DisableAskAQuestionDropdown = OnOff
Application.CommandBars.DisableCustomize = OnOff
End Sub

Heinz