The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by How to prevent or disable edit mode by double clicking cell in Excel?.How to disable right click on sheet tab in Excel?.How to disable cut, copy and paste functions in Excel?.

MsgBox ('Sorry Right Click is Disbaled for this Workbook'), _įrom now on, when you try to right click on any cell in the workbook, a Kutools for Excel dialog box will pop up to remind you the right-click menu has been disabled. VBA code: Disable the right-click menu in the whole workbook in Excel Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean) In the Microsoft Visual Basic for Applications window, please double click ThisWorkbook in the left Project pane, then copy and paste the below VBA code into the ThisWorkbook (Code) window. In the workbook you need to disable the right-click menu, please press the Alt + F11 keys to open the Microsoft Visual Basic for Applications window.Ģ. You can also disable the right-click menu in the whole workbook with the following VBA code.ġ. Press the Alt + Q keys to exit the Microsoft Visual Basic for Applications window.įrom now on, when you try to right click on any cell of this worksheet, you will get a Kutools for Excel dialog box as below screenshot shown.ĭisable the right click menu in the whole workbook with VBA code MsgBox ('Sorry Right Click is Disbaled for this Worksheet'), _ģ. VBA code: Disable the right-click menu in specified worksheet in Excel Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) Please copy and paste the below VBA script into the Code window. Then the Microsoft Visual Basic for Applications window pops up. Open the worksheet you want to disable the right-click menu, right click the sheet tab and then click View Code from the context menu.Ģ. This section is talking about disabling right-click menu in specified worksheet with VBA method. Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!

Excel right click copy not working