Lock different properties for different cells

Originally Posted by seron

Is it possible to lock different properties for different cells?

I have a worksheet that the user fills in some values. I'd like most cells to be completely locked while cells which are filled in by the user are set so that only values can be entered, i.e. cell size, format etc. is locked.

Hi,

The standard 'Protect Sheet' will do that, just un-tick the 'Locked' in rightmouse 'Format Cells', 'Protection' for those cells that require data entry .

hth
---

select the cells you want to unlock and unlock them
then protect your sheet

Originally Posted by seron

Thanks, that worked.

Unfortunately that doesn't prevent formating to be altered when the user pastes someting into those cells. How could I prevent formating to be pasted? I would like paste to work as paste_values_only for those cells, but how? Perhaps there's a way to override the paste command. Any suggestions?

Hi,

there is, but it would involve VBA code that did an 'UNDO' , then a copy of the formats, and a re-apply of the formats after the (Re-Do) Paste etc, not a pretty sight.

Perhaps some User training (and a big stick) might prove more useful?

Otherwise a Macro that sets the required formats, that can be re-run after the user errs and loses the setting.

hth
---

Originally Posted by seron

Thanks Bryan.

I found that I could force some formating with the help of conditional formating. It's limited with less options but it can do things like background and font colour and size as well as some borderline settings.

good to see, also, if the range to be formatted is a fixed range, you can record a macro whilst selecting the Sheet and setting the format, and then place that code in the WorkBook_Open routine, this would reset the format every time the book was opened.

Just another option.
---