Amazing Increase your productivity in 5 minutes. Dont need any special skills, save two hours every day 200 New Features for Excel, Make Excel Much Easy and Powerful. How to export and save each worksheet as new workbook in Excel Lets say you want to export and save one or several worksheets as a new workbook, how will you deal. How to disable cut, copy and paste functions in Excel Supposing you have a workbook with important data which you need to protect from being cut, copied and pasted. How to achieve it This article provides a VBA method for you to disable the cut, copy and paste functions at the same time in an Excel workbook. Disable cut, copy and paste functions with VBA code. Disable cut, copy and paste functions with VBA code. Please do as follows to disable the cut, copy and paste functions in an Excel workbook. Fud/FileDownloadHandler.ashx?fid=014aadd6-335b-4b26-9031-cbe6eb16f804' alt='Paste Special Microsoft Excel Worksheet Object In Word' title='Paste Special Microsoft Excel Worksheet Object In Word' />In the workbook you need to disable the cut, copy and paste functions, please press the Alt F1. Microsoft Visual Basic for Applications window. In the Microsoft Visual Basic for Applications window, please double click This. Workbook in the left Project pane, and then copy and paste the below VBA code into the This. Workbook Code window. See screenshot VBA code Disable the cut, copy and paste functions at the same time in Excel. Private Sub WorkbookActivate. Application. Cut. Copy. Mode False. Application. On. Key c,. Application. Cell. Drag. And. Drop False. Private Sub WorkbookDeactivate. Application. Cell. Drag. And. Drop True. Application. On. Key c. Application. Cut. Copy. Mode False. Private Sub WorkbookWindow. ActivateBy. Val Wn As Window. Application. Cut. Copy. Mode False. Paste Special Microsoft Excel Worksheet Object In Word' title='Paste Special Microsoft Excel Worksheet Object In Word' />Application. Flash Game Source Code Actionscript 3. On. Key c,. Application. Cell. Drag. And. Drop False. Private Sub WorkbookWindow. DeactivateBy. Val Wn As Window. Application. Cell. Drag. And. Drop True. Application. On. Key c. Application. Cut. Copy. Mode False. Private Sub WorkbookSheet. Selection. ChangeBy. Val Sh As Object, By. Val Target As Range. Application. Cut. Copy. Mode False. Private Sub WorkbookSheet. ActivateBy. Val Sh As Object. Application. On. Key c,. Kubuntu 9.10 I38.Iso. Application. Cell. Drag. And. Drop False. Application. Cut. Copy. Mode False. Private Sub WorkbookSheet. DeactivateBy. Val Sh As Object. Application. Cut. Copy. Mode False. End Sub. 3. Then please press the Alt Q keys to exit the Microsoft Visual Basic for Applications window. Now you cant cut or copy data from this workbook, meanwhile, data you have copied from other sheets or workbooks cannot be pasted into this workbook. Note The drag and drop function is also disabled after running the above VBA code. Related articles Recommended Productivity Tools Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer. Amazing Increase your productivity in 5 minutes. Dont need any special skills, save two hours every day New Features for Excel, Make Excel Much Easy and Powerful Merge CellRowsColumns without Losing Data. Combine and Consolidate Multiple Sheets and Workbooks. Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion. Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,More SelectInsertDeleteTextFormatLinkCommentWorkbooksWorksheets Tools.