I do not have control over where users copy from (usually an external source like a browser, another workbook, etc.). So I used the below code in my sheet and assigned CTRL+V to the macro. It works fine when the sheet is unprotected, but throws an error (1004: PasteSpecial method of Range class failed) if protected.
I don't want users to modify the locked cells in my sheet, so I want it protected at all times. Is there anyway around this?
Please Login or Register to view this content.