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?

Read bottom 3 sentences first.

Hide the sheets except for the input sheet.

Protect the workbook under ToolsProtectionProtect 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

On Sun, 9 Mar 2008 15:37:00 -0700, Brooks
wrote:

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?

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

"Brooks" wrote:

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?