Copying of cell overwrites Lock Format

  • Thread starter Thread starter carlo
  • Start date Start date
C

carlo

Hello Everybody

I have the following issue:

I have a sheet, which is protected with "select unlocked cells" only.
That makes sure, that the user cannot change the format of one of
the unlocked cells.
Let's say A1 is unlocked, the rest is locked. Formatted as Arial 12,
no Background nothing.

Now try the following. Go to another sheet, enter something in a
cell and format it completely different, then copy and paste it onto
your protected sheet to A1.
Excel accepts the change of format.

Is there a way around that?
I could do it in VBA without big problems, but my Boss doesn't want
VBA involved.

Thank you in advance for your help

Cheers carlo
 
Hey Peter

thank you very much for your answer. I thought that this could only be
done in VBA.

The problem is not VBA itself, it's the macro warning that pops up due
to our company policy of excel security.

Best regards and thank you very much

Carlo
 
Back
Top