J
Junior Trimon
The following code gives an action for double clicking on
a cell in a sheet.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As
Excel.Range, Cancel As Boolean)
MsgBox "You double clicked on cell " & Target.Address
Cancel = True
End Sub
Now I want to add a restriction with this action.
I want this code to work only for a specific range on the
sheet.
Is this possible?
a cell in a sheet.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As
Excel.Range, Cancel As Boolean)
MsgBox "You double clicked on cell " & Target.Address
Cancel = True
End Sub
Now I want to add a restriction with this action.
I want this code to work only for a specific range on the
sheet.
Is this possible?