Copying of cell overwrites Lock Format

[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

 

[Billy Liddel]

Carlo

It can only be done with VB. Ken Puls has already written the code for this
and you can download a copy from:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=373

Perhaps if your boss sees it in action he will be less restrictive.

Regards
Peter

 

[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