VBA Code to Disable Copy and Paste in Excel

In Excel for Microsoft 365 on Windows, VBA can intercept common copy, cut, and paste shortcuts such as Ctrl+C and Ctrl+V. It cannot reliably prevent someone from copying visible data: the ribbon, context menus, other programs, and screenshots may still provide ways to get it.

What VBA Can—and Cannot—Block

Excel’s Application.OnKey method assigns a macro to a keyboard shortcut. You can use it to replace a shortcut’s normal action with a message, or to make the shortcut do nothing. The example below intercepts Ctrl+C, Ctrl+V, Ctrl+X, Ctrl+Insert, and Shift+Insert while the workbook’s shortcuts are registered.

That is a limited deterrent, not a data-security boundary. A person may still copy through Excel’s Home ribbon, a right-click menu, the formula bar, another open workbook, or another application. They may also take a screenshot or manually retype information. VBA cannot make data that is displayed on a screen impossible to reproduce.

This distinction matters: intercepting a few keys can reduce accidental or casual copying, but it is not a substitute for controlling who can access a file. If the information is confidential, use appropriate access controls and share only what each recipient needs.

VBA Code for Common Copy and Paste Shortcuts

Put the first block in a standard VBA module. It assigns five shortcuts to a message macro. To block only copying and pasting, remove the lines for Ctrl+X, Ctrl+Insert, and Shift+Insert. The final three assignments restore Excel’s default shortcut behavior when called.

Option Explicit

Public Sub ApplyCopyPasteBlock()
    Dim macroRef As String

    ' Point the shortcut assignments to this workbook's macro.
    macroRef = "'" & Replace(ThisWorkbook.Name, "'", "''") & "'!BlockCopyPaste"

    Application.OnKey "^c", macroRef          ' Ctrl+C
    Application.OnKey "^v", macroRef          ' Ctrl+V
    Application.OnKey "^x", macroRef          ' Ctrl+X
    Application.OnKey "^{INSERT}", macroRef   ' Ctrl+Insert
    Application.OnKey "+{INSERT}", macroRef   ' Shift+Insert
End Sub

Public Sub RestoreCopyPasteKeys()
    ' Omitting the procedure restores Excel's normal key behavior.
    Application.OnKey "^c"
    Application.OnKey "^v"
    Application.OnKey "^x"
    Application.OnKey "^{INSERT}"
    Application.OnKey "+{INSERT}"
End Sub

Public Sub BlockCopyPaste()
    MsgBox "Copying or pasting with this shortcut is disabled in this workbook.", _
           vbInformation, "Workbook restriction"
End Sub

For automatic registration and cleanup, put the next event procedures in the ThisWorkbook code module, not in the standard module. The open event applies the shortcuts when macros are enabled; the close event restores their default behavior when the workbook closes.

Option Explicit

Private Sub Workbook_Open()
    ApplyCopyPasteBlock
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    RestoreCopyPasteKeys
End Sub

Save a backup copy before running or changing VBA. Macros cannot be undone with Ctrl+Z, and a mistake in a macro can affect the current Excel session.

How to Add and Run the Code

Save the workbook as an Excel Macro-Enabled Workbook (.xlsm) using File > Save As. A regular .xlsx file does not store VBA macros.
Open the Visual Basic Editor with Alt+F11 on Windows. In the Project pane, select the workbook, choose Insert > Module, and paste the first code block into that module.
In the same project, open ThisWorkbook and paste the event procedures there. Do not paste them into a worksheet module or the standard module; Excel expects workbook events in the workbook object.
Save, close, and reopen the workbook, then allow its macros only if you trust the file and its source. Workbook_Open runs when the workbook opens with macros enabled.

You can also run ApplyCopyPasteBlock manually from the VBA editor or Excel’s Macro dialog. Run RestoreCopyPasteKeys to return the listed shortcuts to Excel’s normal behavior. In Excel for Mac, the Visual Basic Editor and keyboard mappings differ; test the mappings on the target Mac rather than assuming that Windows Ctrl-key bindings match Mac Command-key shortcuts.

What Happens When a Shortcut Is Pressed

The key strings in the code use Excel’s OnKey notation: ^ means Ctrl and + means Shift. Thus ^c represents Ctrl+C, while +{INSERT} represents Shift+Insert. When one of the assigned shortcuts is pressed, Excel calls BlockCopyPaste instead of carrying out the shortcut’s usual action.

The example displays a message each time, which makes the restriction visible but can become irritating if someone presses a blocked shortcut repeatedly. To make the shortcut do nothing, replace the assignments’ macroRef argument with an empty string, for example Application.OnKey "^c", "". Keep in mind that a silent block can confuse legitimate users who expect the standard shortcut to work.

The example does not clear the Windows clipboard. If a user copied something before opening the workbook, that clipboard content remains available. Nor does blocking Ctrl+C erase data already copied by another route. The code only changes Excel’s response to the specified keys while the assignments are active.

Important Limits and Scope

Application.OnKey is application-level rather than a dependable, worksheet-level security setting. While the mappings are in place, they can affect shortcuts in other workbooks open in the same Excel instance, not just cells in the workbook that installed them. That can surprise a user who switches to a different workbook.

The close event is intended to clean up the mappings, but it may not run if Excel crashes, the VBA project is reset, or macros are disabled. If a shortcut seems broken after closing the workbook, run RestoreCopyPasteKeys while the macro is available, or close and reopen Excel. The cleanup procedure restores Excel’s default behavior for these keys; it cannot recover a custom mapping another add-in or macro had assigned earlier.

Also, the code blocks only the listed key combinations. It does not disable the Copy or Paste buttons on the ribbon, every context-menu command, drag-and-drop, or other keyboard combinations. Adding more key bindings may deter more casual use, but it still cannot turn an editable, visible workbook into a secure viewer.

Does Worksheet Protection Prevent Copying?

Worksheet protection is mainly intended to restrict editing, not to conceal information. In Excel for Microsoft 365 on Windows, use Review > Protect Sheet to choose which actions users may perform on a protected sheet. You can leave cells locked while allowing selected cells to be edited, or restrict selection options. The exact available permissions depend on the protection settings.

Protection can help prevent accidental changes, but it should not be presented as a reliable way to stop copying visible cell values. If users can see the values, they may be able to reproduce them by another route. Protecting workbook structure similarly controls workbook organization, such as adding or moving sheets; it does not make displayed data secret.

Use a password for sheet protection only with a clear understanding of its purpose and limitations. It is not equivalent to encrypting a file or restricting access to authorized people. For sensitive data, store and share the source using an access-controlled service, and avoid including information a recipient does not need.

Safer Alternatives for Protecting Workbook Data

Choose a control based on the actual risk. If the goal is simply to discourage accidental copying in a small internal workbook, shortcut interception may be enough as a convenience measure. If the goal is to stop edits, protect the sheet and unlock only intended input cells. If the goal is confidentiality, rely on access control and minimize what the recipient can view rather than relying on VBA.

Share a reduced copy: Remove confidential rows, columns, sheets, comments, and hidden data before sharing. Hiding a sheet is not the same as removing its contents.
Use view-only access where appropriate: A cloud sharing service can limit who may open or edit a file, subject to the options and policies available in that organization. View-only access does not guarantee that displayed information cannot be captured.
Encrypt the file or use organizational controls: Follow your organization’s approved Microsoft 365 or information-protection policies. Confirm that the recipient and use case are covered; do not treat a workbook macro as encryption.
Use sheet protection for editing restrictions: This is useful for preserving a template or calculation layout, but it is not a confidentiality feature.

These approaches address different problems. A workbook may need both edit protection and access controls, but neither should be described as a universal copy-prevention switch.

Common Problems and Troubleshooting

If nothing happens when you press Ctrl+C or Ctrl+V, first confirm that the file is .xlsm, macros are enabled for this trusted file, and the event code is in ThisWorkbook. Then check that the standard module contains ApplyCopyPasteBlock and BlockCopyPaste with public declarations. A compile error or misspelled macro name can prevent the assignment from working.

If the shortcuts stop working in other workbooks, the application-wide scope is the likely reason. Close the workbook normally so its close event can restore the mappings. If the mapping remains, run the restore macro or restart Excel. Do not assume that closing a window or disabling macros will always run cleanup code.

If Copy still works from the ribbon or a context menu, that is expected: the sample intercepts keyboard shortcuts only. If a recipient opens the file with macros disabled, the VBA will not run, and Excel’s ordinary keyboard shortcuts will remain available. Macros should not be treated as an enforceable policy for recipients who can choose whether to enable them.

Frequently Asked Questions

Can VBA completely disable copy and paste in Excel?
No. VBA can intercept selected Excel keyboard shortcuts, but it cannot reliably prevent copying through every menu, application, or screen-capture method. It is a deterrent, not a security guarantee.

Does protecting a sheet stop users from copying cells?
Sheet protection is designed primarily to restrict changes and selected actions. It does not reliably make visible cell contents uncopyable or confidential.

Will this code work if macros are disabled?
No. Excel does not run the workbook’s VBA events or shortcut assignments when its macros are disabled, so the shortcuts keep their normal behavior.

Why are copy shortcuts affected in another workbook?
Application.OnKey changes key handling for the Excel application instance, not just one worksheet. The code restores its mappings on normal workbook close, but overlapping macros or an interrupted session can cause conflicts.

Can I block only paste and still allow copying?
Yes. Keep the assignment for ^v and, if desired, +{INSERT}; remove the assignments for ^c, ^x, and ^{INSERT}. This still blocks only those paste shortcuts, not every paste route.

Does the code work the same way on Excel for Mac or Excel for the web?
No. Mac keyboard conventions differ, so verify and adapt shortcut mappings on the target Mac. Excel for the web does not run VBA macros; use the desktop Excel app to run this code.

Try it: the Column Letter to Number: aA is 27, XFD is 16,384. Converts both ways.

More in VBA & macros

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.