How to Stop Excel VBA Clipboard Conflicts by Disabling Windows Clipboard History
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.

- 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 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.
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.
Press Windows logo key + I or open Start > Settings.
Select System, then click Clipboard in the left menu.
Under Clipboard history, switch the toggle to Off.
Click the Clear button to remove previously saved clipboard items.

Change Excel VBA Code to Avoid Clipboard Copy-and-Paste
Use this solution when you cannot or do not want to change Windows settings, or when the macro should run without invoking the clipboard.
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. Open the macro-enabled workbook: Launch WPS Office Spreadsheets and open your .xlsm or .xls file.
- 2. Open the VBA editor: Press Alt+F11 to open the macro editor.
- 3. Edit clipboard-based statements: Replace Range(...).Copy and Range(...).PasteSpecial with direct assignments, such as Range("B2").Value = Range("A2").Value.
- 4. Save the workbook: Save it as Excel Macro-Enabled Workbook (.xlsm) to keep the macro code.
- 5. Run the macro: Run the macro and confirm data transfers without triggering Clipboard History.

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.




