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

CommandBars("Toolbar List").Enabled = False
--
Jim
"Gordon" <(E-Mail Removed)> wrote in message
news:ECB7F8D4-6817-47BD-85CA-(E-Mail Removed)...
| 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...
|
|

Big Green tick for you!!!!

"Jim Rech" wrote:

> CommandBars("Toolbar List").Enabled = False
> --
> Jim
> "Gordon" <(E-Mail Removed)> wrote in message
> news:ECB7F8D4-6817-47BD-85CA-(E-Mail Removed)...
> | 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...
> |
> |
>
>