Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tab question
Greetings to all
When I right click the tab of a worksheet, I get the option to "View Code". I'd like to remove this option but have been unsuccessful so far. (both the worksheet and workbook are already protected). any clues? Thanks, anny |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tab question
Hi
In VBA editor, right-click on your VBA-project, and select Properties. Activate Protection tab, check 'Lock project for viewing', and set a password. Close VBA editor and then workbook. When the workbook is opened next time, after selecting 'View Code' the user is asked for password. Ari Laanemets "anny" wrote in message ... Greetings to all When I right click the tab of a worksheet, I get the option to "View Code". I'd like to remove this option but have been unsuccessful so far. (both the worksheet and workbook are already protected). any clues? Thanks, anny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table question | Excel Discussion (Misc queries) | |||
Follow-Up (Clarification) to MIN question | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |