Protecting sheets & workbooks

[Brian Ferris]

Good morning ...

Just two short questions ...

a. What is the exact scope of protecting a WORKBOOK and
not a SHEET ... what does a workbook prevent you from
doing once it is protected

b. When protecting a sheet or workbook, the user is still
somehow allowed to right click on the sheet name and view
and edit the code assigned to that workbook.... Is there
some way this can be prevented ...?

Thanks in advance,
Brian

 

[Dave Peterson]

a. Take a look at "workbook protection" in excel's help. There are a couple of
settings that you can enable that allow the user to do fewer things.

b. Inside the VBE, you can lock the project.
Tools|VBAProject Properties|Protection tab.
Give it a memorable password and lock the project for viewing.

These passwords can be broken. Workbook pretty simply. The VBE a little
harder--might cost the person who wants to see the code some money.