View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default msoBarNoCustomize

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