Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
limited access spreadsheet
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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200901/1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
limited access spreadsheet
Hi,
Unprotect the sheet select the cells you want others to edit right click on themCell formattingProtection 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" wrote: 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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200901/1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
limited access spreadsheet
thanks for the speedy responce
what i am looking for is only the other user to format, not amend/add data ideas? Suleman Peerzade wrote: Hi, Unprotect the sheet select the cells you want others to edit right click on themCell formattingProtection 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 -- Message posted via http://www.officekb.com |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
limited access spreadsheet - allow format change only
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) "BNT1 via OfficeKB.com" wrote: 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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200901/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limited in Exporting Access to Excel to 65,000 Rows | Excel Discussion (Misc queries) | |||
Removed content in right columns and limited size of spreadsheet | New Users to Excel | |||
link spreadsheet to access? | Excel Discussion (Misc queries) | |||
need help with using VBA to access a second spreadsheet | Excel Discussion (Misc queries) | |||
Spreadsheet/VBA Project Consulting: 50% Discount or Even Free - Limited Time Only | Excel Worksheet Functions |