Thread: Tab question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets
 
Posts: n/a
Default 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