Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
other user cannot format cells
I protected a sheet in a workbook, and check off "allow other users to format
cells" Upon emailing the file to another, she is unable to change the fill color in a cell. Suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
other user cannot format cells
Just a couple of questions...
What version of excel are you using? What version of excel is she using? That granular level of protection (giving you the choice to allow that stuff) was added in xl2k. If she's running xl2k or earlier, then your settings won't help her. carrera wrote: I protected a sheet in a workbook, and check off "allow other users to format cells" Upon emailing the file to another, she is unable to change the fill color in a cell. Suggestions? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
other user cannot format cells
I'll give that a shot.
"Dave Peterson" wrote: Just a couple of questions... What version of excel are you using? What version of excel is she using? That granular level of protection (giving you the choice to allow that stuff) was added in xl2k. If she's running xl2k or earlier, then your settings won't help her. carrera wrote: I protected a sheet in a workbook, and check off "allow other users to format cells" Upon emailing the file to another, she is unable to change the fill color in a cell. Suggestions? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
user defined functions format | Excel Discussion (Misc queries) | |||
Excel 2007 Pivot table cells number format changes w/out user inpu | Excel Discussion (Misc queries) | |||
In excel how do I protect the format of a cell but let the user c. | Excel Discussion (Misc queries) | |||
How do I format a cell, so the user must use a user calendar? | Excel Discussion (Misc queries) | |||
How do I format a cell, so the user must use a user calendar? | Excel Discussion (Misc queries) |