View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tim[_15_] Tim[_15_] is offline
external usenet poster
 
Posts: 6
Default msoBarNoCustomize

Thanks, Ron. That's the elegant solution I was looking for. Is this kind
of trick documented?

"Ron de Bruin" wrote in message
...
Use this

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

This must be run each time you open the workbook

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Tim" wrote in message

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