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

Need Help With Show/Hide Buttons

ham123

Member
Greeting experts,

I need help creating a code which can help me show/hide rows.

Attached to this post is an example file:

For now, I have this:
59536

By default, everything will be there when the file is opened. For example, for button 1, I need it to be able to show/hide rows 3 to 13 when pressed. For button 2, it will be for rows 16 to 26.

Any help is much appreciated! :)
 

Attachments

  • example.xlsx
    12.5 KB · Views: 0
Hi !

At very beginner level just using the Macro recorder ‼

As a beginner starter :​
Code:
Sub Demo1()
    With Rows("3:13")
        .Hidden = Not .Hidden
    End With
End Sub
Do you like it ? So thanks to click on bottom right Like !
 
Back
Top