msoBarNoCustomize

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hi, Group.

I am looking to prevent the shortcut menu from appearing when the user
right-clicks on a commandbar, but I can't seem to get the right combination
of properties/methods. It looks like msoBarNoCustomize might help, but I am
wondering if there are application-level events that are simpler/preferable.

TIA
 
Use this

Application.CommandBars("toolbar list").Enabled = False

This must be run each time you open the workbook
 
Thanks, Ron. That's the elegant solution I was looking for. Is this kind
of trick documented?
 
Back
Top