Getting rid of command bar chevrons that allow "customize" menu (Excel 2003)

[Travich]

I have seen several topics on this, but no real good answer. One
solution suggested remove the toolbars altogether. Unfortunately, I
want to keep my formatting and standard toolbars on the screen.

I've locked all the other ways to customize a toolbar. If I could
remove this option, I would be set. I've tried several things in VBA
without any luck.

It makes me wonder if it's actually a command bar property that can be
turned off. Anyone know???

 

[Travich]

One other note:
Application.CommandBars("Toolbar list").Enabled = False still allows
the "customize" menu to appear.

 

[Guest]

Hi Travich,

Would this work for you?

Application.CommandBars.DisableCustomize=True

This affects all commandbars in the collection. You should remember to set
it to False when your project closes.

HTH
Garry

 

[Guest]

I failed to mention that my suggestion only applies to v10 and later.
Otherwise, you may have to iterate the commandbars collection and set the
..Protection property for each bar to msoBarNoCustomize.

Regards,
Garry

 

[Travich]

Thanks Gary, that worked great and I found this solution a few days
ago.

I've been able to learn how to completely control EVERYTHING through
locking this down and customizing commandbars. I'm surprised to find
that even a right click falls under command bars. It's been a good
learning experience.