mrwad
New Member
Is there any way to change shape of my buttons to "clicked" when button is clicked? I have shape that looks like button. Above you can see the code that is linked to the button. By clicking button you can hide and unhide rows. I have a lot of butons and would like them to look different if they are clicked. So basically if rows are hidden then Shape 1, if rows are unhidden then Shape 2. Any suggestions?
Code:
Sub UnhideProduct1_Click()
With Rows("296:311")
.Select
.EntireRow.Hidden = Not .EntireRow.Hidden
End With
End Sub