macro needed to disable Excel toolbar options

  Chris the Ancient 20:21 11 Feb 2005

Time for the Excel gurus to get their thinking caps on...

Working in Excel XP.

I have an Excel workbook which has had all the unnecessary toolbars stripped out and my own very simple toolbar (with hardly any functions) put in instead.

I have just noticed at the end of this extremely limited tool bar that is a tiny drop-down arrow which gives a 'toolbar options' that allows add/remove buttons and customise toolbar. I don't want that!

I can't find a way of suppressing that. Any ideas?


  VoG II 20:33 11 Feb 2005

I've just checked one of my applications with a custom toolbar and it too has this accursed little arrow! It didn't used to in Excel 97. I don't want users adding to my special toolbar which has custom button images. It could get extremely confusing.

Thinking cap on...

  Chris the Ancient 20:44 11 Feb 2005

...and the 'help' doesn't!

  Chris the Ancient 20:51 11 Feb 2005

With Application.CommandBars

If .DisableCustomize = True Then

.DisableCustomize = False


.DisableCustomize = True

End If

End With

Doesn't remove the pesky arrow, but it greys out the options!



  VoG II 20:55 11 Feb 2005

Thank you for solving your own problem Chris!

Others please note!

  Chris the Ancient 20:59 11 Feb 2005


That I can solve me own problems if I think about it?

  VoG II 21:00 11 Feb 2005

No- that they can solve their own problems and give me a chance to complete the Telegraph crossword online ;o)

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5T review: Hands-on

See the Best Button Badge Designs of 2017

iPhone X review

Black Friday 2017 : date, sites participants & bonnes affaires