Hello,
I have the following macro that hides selected rows in a table when clicking a shape assigned to the macro:
This works fine. However, I want to add the following so when the same shape is clicked it unhides the selected rows:
I can't seem to figure it out, Any help much appreciated!
Thanks.
I have the following macro that hides selected rows in a table when clicking a shape assigned to the macro:
VBA Code:
Sub Trade_History_Collapse_Table()
'
Range("TableWatchList5911925[#All]").Select
Selection.EntireRow.Hidden = True
End Sub
This works fine. However, I want to add the following so when the same shape is clicked it unhides the selected rows:
VBA Code:
Selection.EntireRow.Hidden = False
I can't seem to figure it out, Any help much appreciated!
Thanks.