Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide "View Code"
Hi,
I am on Excel 2003. I have a spreadsheet I am using the following property in a macro , the user can still view the "View Code" when they write click on a tab. I would like that the "View Code" option be grayed out also along with all the other options(which they are now) ActiveWorkbook.Protect Password:="XXX", Structu=True thanks in advance, Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide "View Code"
Protect the macro project
-- Don Guillett Microsoft MVP Excel SalesAid Software "Dave" wrote in message ... Hi, I am on Excel 2003. I have a spreadsheet I am using the following property in a macro , the user can still view the "View Code" when they write click on a tab. I would like that the "View Code" option be grayed out also along with all the other options(which they are now) ActiveWorkbook.Protect Password:="XXX", Structu=True thanks in advance, Dave |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide "View Code"
Hi Dave,
See the reply of Don, far the easiest way to do. If you really want to disable the "View Code" ... Application.CommandBars("Ply").Controls("&View Code").Enabled=False to gray out, or Application.CommandBars("Ply").Controls("&View Code").Visible=False to hide. With following code you will find the name of each commandbar and the caption of all controls it has. Sub test2() Dim i As Integer Dim j As Integer For i = 1 To Application.CommandBars.Count Debug.Print Application.CommandBars(i).Name For j = 1 To Application.CommandBars(i).Controls.Count Debug.Print , , , Application.CommandBars(i).Controls(j).Caption Next Next End Sub (Excel 2003) Wkr, JP "Dave" wrote in message ... Hi, I am on Excel 2003. I have a spreadsheet I am using the following property in a macro , the user can still view the "View Code" when they write click on a tab. I would like that the "View Code" option be grayed out also along with all the other options(which they are now) ActiveWorkbook.Protect Password:="XXX", Structu=True thanks in advance, Dave |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide "View Code"
If you really want to disable the "View Code" ...
Application.CommandBars("Ply").Controls("&View Code").Enabled=False to gray out, or Application.CommandBars("Ply").Controls("&View Code").Visible=False to hide. Of course, the OP should realize that executing either of those lines of code won't stop the user from being able to press Alt+F11 or clicking Tools/Macro/Visual Basic Editor. -- Rick (MVP - Excel) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
Disable the "view code" option | Excel Programming | |||
Missing "Custom View" entry from View menu | Excel Discussion (Misc queries) | |||
Password visible if user selects "view code" | Excel Worksheet Functions | |||
disabling the "view code" tab - sheet protection? | Excel Programming |