Disable the toolbar options button

[Paul]

Hi,

I'm using Excel 2003.

I've created a custom toolbar for use in a certain document. This is the
only toolbar I would like the user to have access to. Therefore I've disabled
al other toolbars and disbled the "toolbar list". The only thing I can't
disable is the little toolbar option button (with a little down arrow in it)
on the right side of the custom toolbar.

Is there a way to disable this little button?

Cheers,

Paul.

 

[Ron de Bruin]

Read this note from this page
http://www.rondebruin.nl/menuid.htm

Disable right clicking on the worksheet menu bar and other bars in 97 SR1 and above.

On Error Resume Next
Application.CommandBars("Toolbar List").Enabled = False
On Error GoTo 0

This prevents users double-clicking on the Toolbar area to open the
(Customize Toolbars) dialog in Excel 2002 and above.
Application.CommandBars.DisableCustomize = True

If you want to remove “Type a question for Help†on the Worksheet Menu Bar you
can use this in Excel 2002 and above. True = hidden and False = visible
Application.CommandBars.DisableAskAQuestionDropdown = True

You can use this to avoid the error in Excel 2000

If Val(Application.Version) > 9 Then
CallByName CommandBars, "DisableCustomize", VbLet, True
CallByName CommandBars, "DisableAskAQuestionDropdown", VbLet, True
End If

 

[Paul]

Ron,

Thanks for the useful information, good info!

But;

I couldn't get quite what I was looking for;

I couldn't find any reference to the "Toolbar Options" button, It displays
on every toolbar (custom or regular) in excel 2003. (Other versions might as
well, I don't know). It's not a button with a faceID, it's a very narrow
button on the far right of every toolbar. When you click on it it will show a
drop down (sub)menu with " add or remove buttons" when you hoover this
(sub)menu the list with available toolbars will unfold (grayed out because I
disabled that), follow at the bottom with a option to "Customize". This
button i would like to disable / delete / whatever.... as long as the user
can't use it.

Any ideas?

Cheers,

Paul

 

[Ron de Bruin]

Hi Paul

Application.CommandBars.DisableCustomize = True

The arrow is still there but the options in the menu are disabled

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

 

[Paul]

Ron,

Thanks, I'll try it as soon as I get back from my vacation!!

Cheers,

Paul