| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I activate cell shading in a protected worksheet?
I protected the spreadsheet that I was working on except for some cells that
needed to be accessed by other employees. But I could not color shade the unprotected cells when worksheet protection is activated. |
|
#2
|
|||
|
|||
|
Hi
in Excel 2002 you can allow formatting in the 'Tools - Protection' dialog -- Regards Frank Kabel Frankfurt, Germany "unprotect cell shading" <unprotect cell schrieb im Newsbeitrag ... I protected the spreadsheet that I was working on except for some cells that needed to be accessed by other employees. But I could not color shade the unprotected cells when worksheet protection is activated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
| Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
| Worksheet name and Backward compatibility | Excel Discussion (Misc queries) | |||
Linear Mode
