Microsoft Office Forums - View Single Post - [Solved] Worksheet_BeforeDoubleClick

Thread: [Solved] Worksheet_BeforeDoubleClick

View Single Post

Old

02-20-2018, 05:26 AM

Debaser

Debaser is offline

Debaser uses Windows 7 64bit

Windows 7 64bit Debaser uses Office 2010 32bit

Debaser uses Office 2010 32bit

Office 2010 32bit

Competent Performer

Join Date: Oct 2015

Location: UK

Posts: 221

Debaser will become famous soon enough

Default

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

Reply With Quote