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
If Not Application.Intersect(Target, Range("s25")) Is Nothing Then
Columns(35).EntireColumn.Hidden = Not
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.