Tab question

A

anny

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
 
A

Arvi Laanemets

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
 
Top