Cell Protection

S

Susan

Hello,
Have a worksheet on a shared drive. Need to protect
certain cells for viewing only. Need to have adjacent
cells available for comments by the viewers. Have followed
the directions on help. But not working. Help please.
Thank you all.
Susan
 
J

Jan Karel Pieterse

Hi Susan,
Have a worksheet on a shared drive. Need to protect
certain cells for viewing only. Need to have adjacent
cells available for comments by the viewers. Have followed
the directions on help. But not working. Help please.
Thank you all.
Click to expand...

This involves these steps:

Select all cells (click on the box left of the A and above the 1) and
lock them (Edit, Format cells, protection tab, check "Locked").
Normally all cells are locked by default.

Now select the cells you want to be accessible and unlock them (see
above, uncheck "Locked")

Now protect the worksheet: Tools, Protection, "Protect Sheet"

Select the things you want the user to be able to do and enter a
password if needed.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
J

Jan Karel Pieterse

Hi Susan,
Does not work, have tried this. Being shared is a factor.
Click to expand...

Then first unshare the workbook, set all protections as mentioned
above, then reshare the workbook.

BTW: I always advise against sharing workbooks, Excel isn't reliable at
sharing workbooks at all.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
G

Guest

You could download the third party tool: AddinTools Assist from
http://www.addintools.com. It will temporarily display unlocked cells and
locked cells with different background colors. You will find out which are
locked cells, which are unlocked cells immediately. The "To Lock" button and
"To Unlock" button could lock or unlock the selected cell immediately. In
this way, you can decide fast which part of spreadsheet allows changing, and
which part disallows.
The function is very useful when you have forgotten which cells are locked
in a workbook or sheet.
 

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

Insert Comments on a Protected Worksheet 1
Cell Protection 1
Protection of cells in a worksheet 2
How do I protect a number of sheets allowing the user to add a com 8
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel VBA For excel 0
Show message on locked cells 3
How to tell if a cell is protected 4

Top