Lock Worksheet to protect Conditional Formatting

[meckenroth]

I have a workbook with conditional formatting. Other users enter data into this file on multiple tabs (this is a travel report broken out my month so formatting is consistent on each tab) and they like to copy and paste data, messing up my conditional formatting. I see I can protect the workbook to prevent users from being able to mouse click the copy/paste, but I haven't found a way to prevent them from using the old fashioned keyboard short cut Ctrl+C, Ctrl+V.

Is there a way to:
A.) create a pop up message if a user tries to Ctrl+C it, telling them not to
Or
B.) actually lock the file to prevent them from doing that, but they STILL need to be enter data into cells.
Or
C.) have a macro that will automatically conditional format the cells based on certain criteria, thus allowing the user to manipulate the cells without messing up the Conditional Formatting? I will upload a copy of my workbook if this is the only option available. I hate macros because I just can't understand them!!! Please tell me there is another way!!!!!

Thanks in advance for any suggestions and help. If you start talking VBA, I will be lost so dumb it waaaaay down.

[tim201110]

Excel is for users not for lamers.There is no reliable protection in Excel against them.

[meckenroth]

As it turns out they can also use the Ribbons copy/paste feature to mess up the conditional formatting. When I originally tested that, the ribbons copy/paste wouldn't work, I'd get that message box about the workbook being protected. But now it does it without a hitch. I thought I had at least a partial solution, but now I really have nothing.

You'd think Excel would have figured out a way to solve this issue! I mean, you need to protect a workbook for a reason! If ever anybody does come up with a workable solution, please post it.

For now I guess I will leave the workbook unlocked and let them wreck havoc so I can go in and fix it.

[newdoverman]

You could record a couple of macros that do nothing at all and assign one to be Ctrl+C and the other Ctrl+V.