Disabling the View code option

V

vissu

How to disable the view code option for the worksheets .
This is to prevent the user of the workbook from seeing the code.
I know that a password can be kept , but disabling it seems to be a
better option.

Your comments/ suggestion are welcome...
 
W

whisperer

If it is the formulae contained in the cells of your worksheet that you
want hidden then you need to select the cells concerned and then using
<Format><Cells> select the Protection tab and ensure that the Locked
and Hidden boxes both have ticks in them.

You then pasword lock the sheet and the formulae are hidden from view.

If it is the VBA code then you right click on the Project, select
Protection and then place a tick in the box 'Lock project for viewing',
again a password is required to lock the code from prying eyes.

Best wishes
:)
 
J

Jim

In the VBE Editor, Tools>Options>Project Properties>Protection. Assign a
password if you like. Do not forget it...VBE passswords are more difficult
to break that ws or wb passwords, I hear.
 
Top