Paste Special Error 1004

Hi All,

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.

Add a line at the beginning and one at the end of sub to unlock and lock the sheet. eg:

Please Login or Register  to view this content.

Hi DJ... I still get the same error and when I try again it works.

My guess: Since I'm copying before the macro run, unprotecting the sheet clears the clipboard. So when I run the macro again, the sheet is already unprotected and hence it works.

Is there anyway I can crack this? Or even a completely different approach? My aim is to restrict users to paste only values into my (protected) sheet. Any help would be greatly appreciated!