Edit locked cells but not copy them

If you can select a cell, you can copy it, even if you can't otherwise edit it.

It is possible to do this with some VBA. To make it apply only to certain cells would be a bit more involved. Would you consider a VBA solution?

If you are going to use VBA, then my preferred alternative would be to create a user interface (UserForm) to populate the cells, rather than allowing the user to directly access the worksheet. A design for that would be very specific to what you're doing, not enough info in your post to actually do it.

I am trying to find a workaround using excel to use the editable cell as a signature code. Cell A1 reads cell A3 and returns the users first and last name in script. I have tried a VBA, & it "worked". It eliminated the use of "Ctrl+C" but it slows down most of the computers drastically. Some of our uses use "Ctrl+C", others right click and copy, and some even use the Home Ribbon and hit copy. We have multiple shared computers and need a way to validate who is actually signing.

Here is some sample code I got elsewhere. I have not tested it myself yet. It could be modified to be in effect only for certain cells. It covers the key shortcut as well as menu clicks.

I can't guess at why your code slowed things down without seeing the code.

Please Login or Register  to view this content.