macro needed to disable Excel toolbar options

  Chris the Ancient 20:21 11 Feb 05

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 05

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 05

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

  Chris the Ancient 20:51 11 Feb 05

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 05

Thank you for solving your own problem Chris!

Others please note!

  Chris the Ancient 20:59 11 Feb 05


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

  VoG II 21:00 11 Feb 05

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.

Surface Pro 5 News - release date, UK price, features, specs

Microsoft Surface Studio hands-on review: the iMac killer is here

Best Mac antivirus 2017