locking a sheet

  • Thread starter Thread starter Brooks
  • Start date Start date
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?
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Is this possible?? 3
Lock location of sheet within a spreadsheet 4
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
Cursor does not move on protected sheet 5
HELP - A formula or sheet you want to move or copy contains the name .... 0
how can i lock a sheet in an excel file???? 3
Excel Move or Copy Stopped Working? 0
copy cells but lock editing 5

Back
Top