Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable right click with a difference
Hi...
I have a workbook (2003) with all command/tool bars removed on workbook_open and right click disabled. However, I have a floating toolbar which can be dragged to the top of each sheet where it docks. When it docks it allows the user to right click and have the option of having any toolbar they want. How can I have my floating toolbar dock and the right click facility in the toolbar area be disabled. Application.CommandBars("Ply").Enabled = False I know this code disables right clicking over the spreadsheet but it doesn't prevent right clicking in the toolbar area. Thanks Gordon... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable right click with a difference
CommandBars("Toolbar List").Enabled = False
-- Jim "Gordon" wrote in message ... | Hi... | | I have a workbook (2003) with all command/tool bars removed on workbook_open | and right click disabled. However, I have a floating toolbar which can be | dragged to the top of each sheet where it docks. When it docks it allows the | user to right click and have the option of having any toolbar they want. | | How can I have my floating toolbar dock and the right click facility in the | toolbar area be disabled. | | Application.CommandBars("Ply").Enabled = False | | I know this code disables right clicking over the spreadsheet but it doesn't | prevent right clicking in the toolbar area. | | Thanks | | Gordon... | | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable right click with a difference
Big Green tick for you!!!!
"Jim Rech" wrote: CommandBars("Toolbar List").Enabled = False -- Jim "Gordon" wrote in message ... | Hi... | | I have a workbook (2003) with all command/tool bars removed on workbook_open | and right click disabled. However, I have a floating toolbar which can be | dragged to the top of each sheet where it docks. When it docks it allows the | user to right click and have the option of having any toolbar they want. | | How can I have my floating toolbar dock and the right click facility in the | toolbar area be disabled. | | Application.CommandBars("Ply").Enabled = False | | I know this code disables right clicking over the spreadsheet but it doesn't | prevent right clicking in the toolbar area. | | Thanks | | Gordon... | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Right Click | Excel Programming | |||
disable right click menu | Excel Programming | |||
Disable Right click | Excel Programming | |||
Disable right-click | Excel Programming | |||
Disable right click | Excel Programming |