Disabling the View code option

  • Thread starter Thread starter vissu
  • Start date Start date
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...
 
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
:)
 
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.
 
Back
Top