Can't format cell color's when protected on older v. of Excel.

G

Guest

Hi,

I am using Excel 2002 and protected different cells on a worksheet. I
protected the worksheet and checked off ALL except for selecting locked
cells.

I sent this file to a friend who is using Excel 2000 and they can't format
any cell to a different color.

When I try it or send it to someone who is using Excel 2002 or newer they
can change the format of the fill color.

Could this be that they are using an older version of Excel?
 
G

Guest

You've hit the nail on the head. The ability to do 'fine tuning' on what is
locked and what isn't wasn't available in Excel 2000. If they go to Tools |
Protection, all they get is protect (or cancel) and that's pretty much it -
no options to permit changes to format, insert/delete anything in locked
ranges, none of that.
 

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

Edit text format in non-protected cells in protected worksheet 1
Locked Property off, but cannot select cell 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Need to add cell comments in unlocked cell on protected worksheet 3
MS Excel 2003 - Autofilter for protected cells 1
Skip Copying a protected cell with subtotal 2
Format cell color? 5
David Biddulph is correct 8

Top