Exact Copy Multiple Cells without changing formula reference Auto Create References to Multiple Sheets Insert Bullets, Check Boxes and more.Select Duplicate or Unique Rows Select Blank Rows (all cells are empty) Super Find and Fuzzy Find in Many Workbooks Random Select.Merge Cells/Rows/Columns without losing Data Split Cells Content Combine Duplicate Rows/Columns.Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.
How to double click a cell and add 1 to that cell value in Excel?.How to auto add/enter current date/time in a cell with double clicking in Excel?.How to add check mark in a cell with double clicking in Excel?.How to disable the right click menu in specified worksheet or whole workbook in Excel?.How to disable right click on sheet tab in Excel?.How to disable cut, copy and paste functions in Excel?.Press the Alt + Q keys to exit the Microsoft Visual Basic for Applications window.įrom now on, to double click on any cell in the whole workbook will not enter the edit mode. VBA code: Prevent to edit cell by double clicking in the whole workbook Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, _īyVal Target As Range, Cancel As Boolean)ģ.
In the Microsoft Visual Basic for Applications window, double click ThisWorkbook in the left Project pane, and then copy and paste the below VBA code into the ThisWorkbook (Code) window. Please press the Alt + F11 keys to open the Microsoft Visual Basic for Applications window.Ģ. This section is talking about preventing to edit cell by double clicking in the whole workbook. Prevent to edit cell by double clicking in the whole workbook Press the Alt + Q keys to close the Microsoft Visual Basic for Applications window.įrom now on, the double click to edit mode has been disabled in range A1:B10 of current worksheet.
Note: In the code, A1:B10 is the range where you will disable the edit mode by double clicking. If Not Intersect(Target, Range("A1:B10")) Is Nothing Then Cancel = True VBA code: Prevent to edit cell by double clicking in a certain range of current worksheet Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) In the popping up Microsoft Visual Basic for Applications window, please copy and paste the below VBA script into the Code window.
In the worksheet which you need to disable edit mode in a certain range by double clicking, please right click the sheet tab and then click View Code from the right-clicking menu.Ģ. If you only want to disable edit mode by double clicking in a certain range of active worksheet, the following VBA code can help you.ġ. 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!