Back to Blog
![]() Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) ![]() Private Sub Workbook_WindowDeactivate(ByVal Wn As Window) Private Sub Workbook_WindowActivate(ByVal Wn As Window) VBA code: Disable the cut, copy and paste functions at the same time in Excel Private Sub Workbook_Activate() In the Microsoft Visual Basic for Applications window, please double click ThisWorkbook in the left Project pane, and then copy and paste the below VBA code into the ThisWorkbook (Code) window. In the workbook you need to disable the cut, copy and paste functions, please press the Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Applications window.Ģ. Please do as follows to disable the cut, copy and paste functions in an Excel workbook.ġ. ![]() 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.ĭisable cut, copy and paste functions with VBA code Supposing you have a workbook with important data which you need to protect from being cut, copied and pasted. How to disable cut, copy and paste functions in Excel?
0 Comments
Read More
Leave a Reply. |