Unhide hidden rows with active button

[amilchev]

Hi guys,

I want to create an active button in excel that will hide/unhide rows when clicked.
The thing is that I will have rows 13-17 hidden. I want on one click of the button to unhide row 13, the second click should unhide row 13 and 14, the next will unhide row 13, 13 and 15 and so on - until row 17. I will create a separate button that upon being clicked will hide rows 13-17. ()

Making the button insert rows is not an option, because I have another button like that further down the sheet and if I add rows above it it messes up the code. The button that is down adds rows between row 33 and 34 and if I add a row between 13 and 14 that will make rows 33 and 34 rows 34 and 35. If you know a way to make the code of the second macro react to rows being added above it that would also work.

Do you think something like that is possible?

Thank you in advance!

Best,
Alexander

[WideBoyDixon]

Button code would look something like this:

Please Login or Register  to view this content.

WBD

[Greg M]

Hi there,

Define Rows 13-17 of your worksheet as a Named Range called "ptrRowsToHide", and then see if the following code does what you need:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Regarding:

If you know a way to make the code of the second macro react to rows being added above it . . .

the most straightforward way to approach this is to define the rows "further down" the worksheet as a Named Range, and to have your VBA code reference rows in the Named Range rather than specifically numbered rows on the worksheet.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[amilchev]

Hi all,

Thank you for your answers. The command button works for un-hiding rows 13 to 17 by clucking it. I was trying to make it do the same for columns D to H, however, for some reason it does not work. Please find the code below. Would appreciate any help.

Please Login or Register  to view this content.

Thank you!

[amilchev]

Hi guys,

I managed to get it to work - the issue was that the columns had to be defined not as D to H, but rather as 4 to 8.

Now the last problem I have is that I have created another button that is supposed to hide rows 13 to 17 and columns D to H when clicked, however, I cannot seem to get it to work. Any suggestions? It should only hide the rows - not make them appear.

Thank you!

Best,
Alex

[WideBoyDixon]

Please Login or Register  to view this content.

WBD

[amilchev]

Hi,

Everything works now! Thanks all for the help!

Please Login or Register  to view this content.

Best,
Alex

[Greg M]

Hi again,

Many thanks for your feedback,

You're welcome - glad I was able to help.

Regards,

Greg M