Others

How to Stop Excel VBA Clipboard Conflicts by Disabling Windows Clipboard History

Bushra ParveenBushra Parveen Nov 13, 2026 869 views

Question details

The user needs to know whether Excel VBA can turn off Windows 10 Clipboard History and how to prevent clipboard features from interfering with macro copy-and-paste operations.

Can Excel VBA Disable Windows Clipboard History?
Product
Microsoft Excel / WPS Office Spreadsheets
Device & OS
Windows 10
Scenario
Clipboard History appears or interferes while an Excel VBA macro performs copy-and-paste operations.
Observed behavior
Excel VBA cannot control Windows Clipboard History because it is an operating-system setting; users must disable it in Windows Settings or change the macro to avoid clipboard operations.
Before you start

Before changing settings or editing a macro, save the active workbook and confirm that you are using Windows 10 or later. Clipboard History options are available in Windows 10 and later versions.

Solution 1Recommended

Turn Off Windows Clipboard History in Windows Settings

Use this solution when you want to stop Clipboard History from appearing during Excel macro copy-and-paste operations.

Windows Clipboard History is controlled by the operating system, not by Excel VBA. Disabling it in Windows Settings prevents new items from being recorded while you run copy-and-paste macros.

1
Open Windows Settings

Press Windows logo key + I or open Start > Settings.

2
Go to Clipboard settings

Select System, then click Clipboard in the left menu.

3
Turn off Clipboard history

Under Clipboard history, switch the toggle to Off.

4
Clear existing history if needed

Click the Clear button to remove previously saved clipboard items.

Turn Off Windows Clipboard History in Windows Settings
After disabling: Turning off Clipboard history stops new entries but does not delete previous items unless you clear them manually.

Use WPS Office Spreadsheets to Manage Macros Without Clipboard History Interference

Edit your VBA macro in WPS Office Spreadsheets to transfer values directly instead of using the Windows clipboard. WPS Office is free, lightweight, and supports familiar Excel macro-enabled workbook workflows.

  1. 1. Open the macro-enabled workbook: Launch WPS Office Spreadsheets and open your .xlsm or .xls file.
  2. 2. Open the VBA editor: Press Alt+F11 to open the macro editor.
  3. 3. Edit clipboard-based statements: Replace Range(...).Copy and Range(...).PasteSpecial with direct assignments, such as Range("B2").Value = Range("A2").Value.
  4. 4. Save the workbook: Save it as Excel Macro-Enabled Workbook (.xlsm) to keep the macro code.
  5. 5. Run the macro: Run the macro and confirm data transfers without triggering Clipboard History.
Avoid Windows Clipboard History interruptions during copy-and-paste macrosTransfer data directly with VBA value assignment instead of clipboard operationsOpen and save Microsoft Excel macro-enabled workbooks (.xlsm) with WPS OfficeFamiliar ribbon, VBA editor, and Excel-compatible file support for easy migration
microsoft office alternative - wps office

Frequently Asked Questions

Can Excel VBA disable Windows Clipboard History?

No, Excel VBA cannot normally disable Windows Clipboard History because it is a Windows operating system feature. Open Settings > System > Clipboard and turn off Clipboard history instead.

Where is the Windows Clipboard History setting in Windows 10?

Press Windows key + I to open Settings, select System, click Clipboard, and toggle Clipboard history off.

How do I make an Excel macro stop using the clipboard?

Open the VBA editor with Alt+F11 and replace Copy/Paste statements with direct value assignments such as Range("B2").Value = Range("A2").Value.

Will clearing clipboard history delete items permanently?

Yes, using the Clear button in Windows Settings > System > Clipboard removes currently saved clipboard history items from the device.

Does WPS Office support Excel macro-enabled workbooks?

WPS Office Spreadsheets supports opening and saving Microsoft Excel macro-enabled workbooks and provides a familiar VBA editor for editing and running macros.