• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel shape change when button clicked

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
 
Back
Top