other user cannot format cells

  • Thread starter Thread starter carrera
  • Start date Start date
C

carrera

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?
 
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.
 
I'll give that a shot.

Dave Peterson said:
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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

protect cell format 1
David Biddulph is correct 8
Excel VBA 1
Excel Can you lock the value of a cell but not the format? 1
Locked Several Worksheets, allow format cells/select unlocked cell 2
Sharing workbooks limitations - Merged Cells 12
Excel Macro to automatically go to the right of the last colored cell 0
Cell fill color in linked cells? 1

Back
Top