Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|