how can i lock a sheet in an excel file????

[najia7cb]

I made an excel of 5 sheets and i want to send it to all my employees, but I
dont want them to have axces in just one sheet....Can I lock this sheet with
a password???

 

[Guest]

you have a few options:

1. you can hide the sheet.
2. you can password protect the sheet with a password, on the review tab in
excel 2007, tools/protection in 2003
3. you can limit the access to just cell a1, for example. alt-F11 to get to
the vb editor,click view then properties window (or press F4), select the
sheet and in the scroll area, enter A1. then they won't be able to select
anything but A1. then if you protect the sheet, they won't be able to select
anything. you can also choose xlveryhidden in the visible dropdown to hide.

not sure what you want, so give them a try and see if any work for you.

 

[trip_to_tokyo]

In EXCEL 2007 take the following actions:-

Assuming that Sheet3 is the sheet that you do not wish your employees to
have access to.

1. Go to Sheet3.

2. Highlight the whole Worksheet by clicking on the cell in the top left
hand corner (the one above row 1 and to the left of column A).

3. Ctrl-1 - this will launch the Custom Lists pop up window.

Protection tab / make sure that Locked option (towards top left hand corner)
has a tick in it.

OK.

4. Home / Cells group / Protect Sheet (window of same name should launch).
Put a password in the box (password for example).

3 fields in this window should have a tick in them:-

Protect worksheet and contents of locked cells

Select locked cells

Select unlocked cells

OK

5. Confirm Password window should launch put:-

password

- into the:-

Reenter password to proceed.

- box.

OK

6. Save the file if required.

7. Close the file and re-open it.

8. If your employees now try to enter information into Sheet3 they will not
be able to do that.

Please hit Yes if my comments have helped.

Thanks.

 

[Gord Dibben]

Home tab will not get you there.

Review Tab>Protect Worksheet is what you want.


Gord Dibben MS Excel MVP