• 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.

Toggle Show/Hide 2 Ranges

Tech56

Member
Hi,

I have 2 sets of rows on my sheet (Transactions) that I want to show/hide. Does anyone know how to do that with macros that are independent of each other?

My first range is rows 5 to 17
My second range is rows 19 to 28

I would like to assign these to shapes that will toggle the ranges please.

Thank you very much

PS I have these codes but they don't work independently:

Code:
Sub ToggleRows1()

    With Rows("5:17")
      .Hidden = Not .Hidden
    End With

End Sub

Sub ToggleRows2()

    With Rows("19:28")
      .Hidden = Not .Hidden
    End With

End Sub
 

Attachments

  • Money Manager 12.8.xlsm
    168.6 KB · Views: 4
Last edited:
Back
Top