#1
|
|||
|
|||
Worksheet_BeforeDoubleClick
Hi all,
I'd like to know how to use the code below on several worksheets that have the same fields, I use different sheets for each of our customers and would like to be able to add a new customer without having to add the vba code to each worksheet. Can I put it in the workbook reference somehow to make it work for all sheets in the workbook, based on the activesheet reference or is this not possible? Sample found on web... Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Not Intersect(Target, Range("A3:A25")) Is Nothing Then 'code 'code 'code End If End Sub Last edited by trevorc; 02-20-2018 at 01:40 AM. Reason: Title update |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
Solved
Thanks for that, It works great.
Last edited by trevorc; 02-20-2018 at 12:20 PM. Reason: tried to set solved but can't get to it ? |
|
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 |