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