PASSWORD PROTECTING SECTIONS OF A WORKSHEET

[Guest]

I need to find out if there's a way to password protect certain sections/rows
of a worksheet. I want to create a spreadsheet, password protect certain
rows so that only those with the password can update information contained in
cells within those rows. However, I want anyone to be able to update
information in cells on other rows that are not password protected. Is that
possible?

Todd

 

[Alan]

Select the whole sheet by left clicking the grey box to the left of column A
and above row 1, right click in the highlighted area, 'Format Cells' >
'Protection' uncheck 'Locked'.
All cells are now unprotected. Select all the cells you want to select by
highlighting the first range, hold down the Ctrl key and select all the
other cells you want to protect. Right click within the highlighted range
and do the reverse of the above, check 'Locked'.
Now protect the sheet, 'Tools' > 'Protection' > 'Protect Sheet' and follow
the prompts, add a password if you wish. That's it done.
Bear in mind though that Excel protection, especially worksheet protection
is weak and easily overcome by anyone with a little VBA knowledge and the
will to do so. Its designed really to prevent accidental overwriting
formula's etc, not for security,
Regards,
Alan.

 

[Guest]

Todd,

Perfectly possible, by default, all cells in a workshee are locked, this
means that once a password is applied, they are un-editable.

for a fuller explanation visit
http://www.nwarwick.co.uk/ExcelCellProtection.htm for an explanation of cell
protection.

HTH

Neil
www.nwarwick.co.uk

 

[Gord Dibben]

Todd

By default all cells on a sheet are locked when the sheet is protected.

CTRL + a(twice in 2003) to select all cells.

Format>Cells>Protection. Uncheck "locked" and OK

Now select the sections/rows to protect and Format>Cells>Protection. Check
"locked" and OK

Tools>Protection>Protect Sheet

The section/row locking does not work if you don't protect the sheet.


Gord Dibben MS Excel MVP

I need to find out if there's a way to password protect certain sections/rows
of a worksheet. I want to create a spreadsheet, password protect certain
rows so that only those with the password can update information contained in
cells within those rows. However, I want anyone to be able to update
information in cells on other rows that are not password protected. Is that
possible?

Todd

Gord Dibben MS Excel MVP