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...
|
|
|