macro needed to disable Excel toolbar options

  Chris the Ancient 20:21 11 Feb 05
Locked

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?

Chris

  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


Else


.DisableCustomize = True


End If


End With


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

Pheeeew!

Chris

  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

Wot?...

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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

These are the Best Christmas Ads and Studio Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…