|
|
|
|
#1
05-19-2018, 08:35 PM
|
|||
|
|||
Code:
Option Explicit
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Intersect(Target, Range("G:V")) Is Nothing Then Exit Sub
Cancel = True
Target.Value = IIf(Target.Value = "", 0, "")
End Sub
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How do I insert pictures directly into picture boxes by clicking the box instead of using INSERT>PIC
|
Bree | Word | 1 | 06-24-2016 10:32 PM |
|
Formula cells are not highlighted when double clicking result
|
hockeytown | Excel | 2 | 12-03-2015 09:57 AM |
|
Can't open Word files when double-clicking
|
JosieNurse | Word | 9 | 04-21-2015 11:31 AM |
| Problem with page and chapter number appearing when clicking in the scroll bar | Tango Mike | Word | 0 | 05-05-2014 07:12 AM |
|
Insert the Hyperlink and hide all sheets except clicking Hyperlink
|
PRADEEPB270 | Excel | 1 | 02-22-2013 09:47 AM |
Windows 10 
Office 2007
Hybrid Mode