Formatting unlocked cells

  • Thread starter Thread starter Bhuktar S
  • Start date Start date
B

Bhuktar S

How to do formatting of unlocked cells?
I have locked certain cells and wish the user to have freedom o
formatting other (unlocked) cells. But once the sheet is protected
formatting etc. are not possible even for unlocked cells.
I am using Excel2000 and under protection password dialogue, the chec
boxes are as 'Contents', 'Objects' & 'Scenarios'.
How to solve the problem
 
If you have excel 2002 onwards you can format cells if you select that
option when you protect the sheet.

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


papou said:
Hi Bhuktar
You can't, this behaviour is by design in Excel.

HTH
Cordially
Pascal
Click to expand...
 
Hi Peo
Yes definitely right!
I always seem to forget about other people's versions.

Cordially
Pascal

Peo Sjoblom said:
If you have excel 2002 onwards you can format cells if you select that
option when you protect the sheet.

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
Click to expand...
 
Back
Top