limited access spreadsheet

[BNT1 via OfficeKB.com]

Hi

The shreadsheet is protected by "password to modify" by one person only
Is it possible to permit another user to amend the colour of the cells only
and not to alter any data in the existing sheet?

regards

 

[Suleman Peerzade]

Hi,

Unprotect the sheet select the cells you want others to edit >>right click
on them>>Cell formatting>>Protection and then uncheck the locked check box.
Protect the sheet and save now the other person can then edit the data in the
unlocked cells.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade

 

[BNT1 via OfficeKB.com]

thanks for the speedy responce

what i am looking for is only the other user to format, not amend/add data

ideas?

Hi,

Unprotect the sheet select the cells you want others to edit >>right click
on them>>Cell formatting>>Protection and then uncheck the locked check box.
Protect the sheet and save now the other person can then edit the data in the
unlocked cells.

Hi

[quoted text clipped - 3 lines]

regards

 

[Lori H.]

lock the cells (format > protection > Locked).
Then when you protect the sheet select allow users to:
"select locked cells" and "format cells"

Locking prevents data edit, protection prevents selection (and/or allows
limited capability in selected cells)