msoBarNoCustomize
 

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

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

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

msoBarNoCustomize
 

I don't believe it is in the help files Tom

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



"Tim" wrote in message ...
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