Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Doubleclick for a range
I am trying to disable the mouse doubleclick for a
certain range of cells (e.g. A1:A10), not the entire workbook as the "Application.EditDirectlyInCell = False" does. I have been spinning my wheels so any help on this would be very much appreciated. Thanks, Brandon |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Doubleclick for a range
This is a duplicate. Thanks Rob, Vasant, Patrick, and
John for your assistance. I will try those and let you know if they worked. Thanks again, Brandon -----Original Message----- I am trying to disable the mouse doubleclick for a certain range of cells (e.g. A1:A10), not the entire workbook as the "Application.EditDirectlyInCell = False" does. I have been spinning my wheels so any help on this would be very much appreciated. Thanks, Brandon . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Doubleclick for a range
Brandon,
Try something like the following in the code module for the appropriate worksheet. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Not Application.Intersect(Range("A1:A10"), Target) Is Nothing Then Cancel = True End If End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Brandon" wrote in message ... I am trying to disable the mouse doubleclick for a certain range of cells (e.g. A1:A10), not the entire workbook as the "Application.EditDirectlyInCell = False" does. I have been spinning my wheels so any help on this would be very much appreciated. Thanks, Brandon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From a Data Range DoubleClick on a cell to populate elsewhere | Excel Discussion (Misc queries) | |||
Disable a range of Cells | Excel Worksheet Functions | |||
doubleclick | Excel Worksheet Functions | |||
Disable Doubleclick | Excel Programming | |||
Before DoubleClick | Excel Programming |