Hi all,
I'm looking to create a Macro that searches the defined ranges (Range1 to 75) in a sheet called "Layout" and if it has a red border then I want it to perform a Macro after users double click on the Range. The Macro will be to unhide rows on a second sheet called "Reports". I have a similar thread using checkboxes and a command button, but based on feedback from users; they'd prefer something different.
What I have so far is:
I'm not sure how to incorporate the double click part and i'm still working on the bordershade: red selection property.
I'm looking to create a Macro that searches the defined ranges (Range1 to 75) in a sheet called "Layout" and if it has a red border then I want it to perform a Macro after users double click on the Range. The Macro will be to unhide rows on a second sheet called "Reports". I have a similar thread using checkboxes and a command button, but based on feedback from users; they'd prefer something different.
What I have so far is:
Code:
Sub CreateReport()
Dim x As Integer
Dim rng As Range
For x = 1 To 75
If rng(x) = bordershade: red Then
Sheets("Reports").Select
[(x-1)*35 +1:x*35].EntireRow.Hidden = False
Else
Sheets("Reports").Select
[(x-1)*35 +1: x*35].EntireRow.Hidden = True
End If
Next x
End Sub