| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable the "view code" option
I have locked down everything on a trial workbook. All menus have been
disabled etc. I've even put a limit to the times you can open it. My problem now is that if the user is "lucky" enough to right click on the top of the active window, it drops down a menu with a "view code" option. this now nullifies everything I've done to protect the document. Please can someone tell me how to disable this "drop down" menu. Any help would be greatly appreciated. -- Callan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable the "view code" option
Try this one
Application.CommandBars("Document").FindControl(, 1561).Enabled = False Or the whole right click menu Application.CommandBars("Document").Enabled = False -- Regards Ron de Bruin http://www.rondebruin.nl "Callan" wrote in message ... I have locked down everything on a trial workbook. All menus have been disabled etc. I've even put a limit to the times you can open it. My problem now is that if the user is "lucky" enough to right click on the top of the active window, it drops down a menu with a "view code" option. this now nullifies everything I've done to protect the document. Please can someone tell me how to disable this "drop down" menu. Any help would be greatly appreciated. -- Callan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable the "view code" option
You're a STAR!
Thanks, the second line worked perfectly. Application.CommandBars("Document").Enabled = False Much appreciated -- Callan "Ron de Bruin" wrote: Try this one Application.CommandBars("Document").FindControl(, 1561).Enabled = False Or the whole right click menu Application.CommandBars("Document").Enabled = False -- Regards Ron de Bruin http://www.rondebruin.nl "Callan" wrote in message ... I have locked down everything on a trial workbook. All menus have been disabled etc. I've even put a limit to the times you can open it. My problem now is that if the user is "lucky" enough to right click on the top of the active window, it drops down a menu with a "view code" option. this now nullifies everything I've done to protect the document. Please can someone tell me how to disable this "drop down" menu. Any help would be greatly appreciated. -- Callan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i disable/enable "Worksheet Move or copy" option? | Excel Worksheet Functions | |||
| Can't Disable the "Insert - Rows" menu option in Excel using VBA m | Excel Programming | |||
| "Show Windows in Taskbar" option from the ToolsOptionsView broke | Excel Discussion (Misc queries) | |||
| Disable "Sheet tabs" check box under [Tools][Options]-[View] tab | Excel Programming | |||
| Code to disable "paste" as an option | Excel Programming | |||
Hybrid Mode
