Hide/Unhide rows with an object

[Juve_Fan14]

Hi Guys,

Hopefully someone can help.

I'm trying to crease a macro to an object which will hide and unhide set rows. I can get a button to do this, but would much prefer to have an image, which is a down arrow that hides several rows below it.

It's used to hide details rows under header rows for finance purposes. For example smaller accounts within a large totalling account. My code for the toggle button works and looks as below, but can't seem to adjust it for an object:

Private Sub ToggleButton1()
If ToggleButton1 Then
Rows("12:15").EntireRow.Hidden = True
Else
Rows("12:15").EntireRow.Hidden = False
End If
End Sub

Any help is much appreciated.

[gue2013]

you need a cell which is not used, e.g. "A1" in this case
you can assign a macro to a shape

Please Login or Register  to view this content.

cheers

[Juve_Fan14]

You are a life saver, worked like a treat.

Thank you very very much.

[gue2013]

welcome

[Fluff13]

You could also do it without helper cells, but have the arrow rotate to show whether it will hide/unhide the rows

Please Login or Register  to view this content.

[gue2013]

perfect solution !

[Fluff13]

Thanks.
Not necessarily any better than yours, I just prefer to have the "Button" change to show what it's going to do.