B
bones288
Hello,
I'm not sure if this is the correct group or not so pls forgive me if
this question is too 'beginner'.
I'm looking to hide/unhide rows 23 through 29 in a worksheet I have if/
when I dbl click on cell C22. The only example I can find that leads
me in this direction is:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
If Not Application.Intersect(Target, Range("s25")) Is Nothing Then
Columns(35).EntireColumn.Hidden = Not
Columns(35).EntireColumn.Hidden
End If
End Sub
But something was mentioned regarding if 'you want to simply toggle
visibility and not enter into edit mode then you'll have to Cancel =
True'. Well, I want only to toggle visibility and don't care for edit
mode. I can get the example above to work for it's intended
purpose. . . but am failing to modify if for my own purposes.
Can someone tell me how to covert the example to work on a range of
rows, and what Cancel = True means and how to implement it.
Thanks for you patients,
Bones
I'm not sure if this is the correct group or not so pls forgive me if
this question is too 'beginner'.
I'm looking to hide/unhide rows 23 through 29 in a worksheet I have if/
when I dbl click on cell C22. The only example I can find that leads
me in this direction is:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
If Not Application.Intersect(Target, Range("s25")) Is Nothing Then
Columns(35).EntireColumn.Hidden = Not
Columns(35).EntireColumn.Hidden
End If
End Sub
But something was mentioned regarding if 'you want to simply toggle
visibility and not enter into edit mode then you'll have to Cancel =
True'. Well, I want only to toggle visibility and don't care for edit
mode. I can get the example above to work for it's intended
purpose. . . but am failing to modify if for my own purposes.
Can someone tell me how to covert the example to work on a range of
rows, and what Cancel = True means and how to implement it.
Thanks for you patients,
Bones