Disable CTRL-V in favor of another paste method

Hello all.

I have this code here that AlphaFrong kindly shared with me.

Please Login or Register  to view this content.

https://www.excelforum.com/excel-pro...ml#post5286089

I am wondering because the sheet is password-protected, is it possible to disable the keyboard use of CTRL+V so that the only way to paste in this particular sheet would be to double click, as the macro above requires?

If CTRL+V is used, maybe instead of the "This worksheet is password protected" pop-up message, the user will be asked to double click to paste?

Thanks!

You could use Application.OnKey to map ^v to a do-nothing macro, e.g., Sub nuttin() : End Sub. However, cleverer users could use Application.OnKey to remove that mapping and revert to standard [Ctrl]+V functionality. There's no way to prevent a clever user from doing that. Thus, you'd be far better off using event handlers, specifically Worksheet_Change, to handle any paste operation the way you need it handled.

Looking at your code, your worksheet is protected, so users can't paste into locked cells anyway. Pressing [Ctrl]+V should result in Excel displaying error dialogs telling users that cells are locked and the worksheet is protected. Since users can't use [Ctrl]+V anyway, what's the problem? If users would be pasting into unlocked cells, why does your BeforeDoubleClick event handler unprotect and reprotect the worksheet?

hrlngrv, thank you for the response.

The data needs to get pasted in a specific way, at a specific column, so when macros run to sort the data, it doesn't create any issues, which is why the BeforeDoubleClick event handler unprotect and reprotect the worksheet.

the macro itself works fine, the only reason I am looking to do this is to guard against users that don't bother to read the instructions before using the sheet.