|
|
#2
02-20-2018, 05:26 AM
|
||||
|
||||
Yes, you need the Workbook level equivalent. This needs to be in the ThisWorkbook module:
Code:
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
If Not Intersect(Target, Sh.Range("A3:A25")) Is Nothing Then
'code
'code
'code
End If
End Sub
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| PIVOT TABLES adding several FILTERS that do not intersect between them | Squall LH | Excel | 0 | 11-09-2017 08:46 AM |
| Intersect | tinfanide | Excel Programming | 1 | 07-27-2014 06:14 AM |
 What application to use?
|
pfergy | Office | 1 | 03-12-2011 08:46 PM |
|
Best application to use?
|
FrankW | Office | 2 | 06-13-2009 01:16 AM |
| Application.Caller | pankajkankaria | Excel | 0 | 03-18-2009 11:48 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode