Q: locking some, but not all, properties of a cell

[Guest]

Folks,

Is there a way of locking the format of a cell, but not
the contents?

We have a shared yearly planner type spreadsheet in which
cells are coloured to indicate vacation, on course, off
sick, etc, and may also contain key letters to indicate
Early or late shifts.

I would like to allow anybody to input shift changes, but
reserve changes in vacation (cell colour) for the
administrator.

Thanks - Mike.

 

[Frank Kabel]

Hi
AFAIK not possible with the build-in protection functionality. This
would require VBA (though checking for a color change is difficult and
would require for example the OnTime method). So in total you may use
something different:
- indicate holidays also with an entry
- use conditional formating for showing colors depending on your entry

 

[MikeC]

-----Original Message-----
Hi
AFAIK not possible with the build-in protection functionality. This
would require VBA (though checking for a color change is difficult and
would require for example the OnTime method). So in total you may use
something different:
- indicate holidays also with an entry
- use conditional formating for showing colors depending on your entry

Thanks for the suggestion, Frank, but if it was all
dependant on data entry into a cell, I couldn't stop users
from entering vacation letters while still allowing them
to enter shift letters.

I can, of course, change the way the spreadsheet works,
but what I need is to allow everybody to enter one set of
criteria while preventing all but the administrator from
entering a different set of criteria. I thought about
using two sets of cells, a protected one for holiday
planning and the other (unprotected) for shift planning,
but there isn't enough space on the screen without
scrolling. It wouldn't look as professional!

Incidentally, I'm not frightened by Excel Basic, if you
have some ideas to give me.

Mike.