VBA help (toggle hide/unhide rows in different worksheet)

[stricker.garrett]

Hello,
I have sheet 1 that will have some questions for user's to answer. The answers will be buttons, assigned to macros'. When a button is clicked, I want sheet 2 to hide/unhide assigned rows...

I can't get my simple macro to hide the correct rows and unhide the rows...

I know if i can create the macro I can then assign it to a button on sheet 1.

Any help would be very much appreciated.

 

[Andrew Poulsom]

Here's an example of a toggle:

Sub Test()
    With Worksheets("Sheet2")
        .Rows("6:10").EntireRow.Hidden = Not .Rows("6:10").EntireRow.Hidden
        .Columns("C:D").EntireColumn.Hidden = Not .Columns("C:D").EntireColumn.Hidden
    End With
End Sub

 

[stricker.garrett]

THANKS! you just made VBA for Dummies make some sense...
I knew it would be simple, but man I couldn't get it!

THANKS!!!

 

[stricker.garrett]

if i rename the sheet2, how do i alter the code to still have it work? I've tried ("sheet2(RENAME)")
("RENAME")
("(RENAME"))

All just came back with an error.

 

[Andrew Poulsom]

Just change Sheet2 to the new name.