Disable right click with a difference

G

Gordon

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

Jim Rech

CommandBars("Toolbar List").Enabled = False
--
Jim
| 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...
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open my default template when right click, select New MS Word doc within a folder 0
Outlook meeting location auto prompts with a suggestion list - need to disable 0
Rows right click menu? 2
reset hidden commandbars using workbook_beforeclose() 3
To disable Right Click Q 1
Custom Right Click--VBA? 4
Right Click - Disable item 1
Textbox (Object) Right Click Menu - Disable Cut 0

Top