locking a sheet

B

Brooks

I have mulitple sheets pertaining to my business that I would like to be
locked so my staff will not be able to view the contents. However one of the
sheets is an input sheet for sales that they will be inputing. So how do you
allow use of only the one sheet?
 
G

Gord Dibben

Read bottom 3 sentences first.

Hide the sheets except for the input sheet.

Protect the workbook under Tools>Protection>Protect Workbook.

Note: Excel's internal security is very weak and the password to unprotect is
easily cracked.

The general rule is...........if it is too sensitive to be shared, don't include
it in the workbook.

For casual users the protection may be enough to keep them out but don't count
on it.


Gord Dibben MS Excel MVP
 
J

Jean-Guy

Hi,

You can hide those sheets and only leave the one (input sheet) visible then
protect your workbook with a password (Tools/Protection/Protect workbook).

HTH
Jean-Guy
 
Top