Blocking Format Changes on Paste
Posted on 2011-09-05
This has always baffled me. If you protect a sheet and disallow format changes, you cannot change the formatting of an unlocked cell - as expected. But if you copy and paste, you can overwrite the formatting and even the validation. That's a very nasty loophole. I've always coded around this by intercepting the paste command, but I hate having to do this every time. Is there another, easier way to solve this problem?