View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Travich Travich is offline
external usenet poster
 
Posts: 7
Default Getting rid of command bar chevrons that allow "customize" menu (E

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. :)

GS wrote:
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