Toggle hide rows

[ma0ffst08]

Hi guys,

Pretty easy one for you, I'm sure.

On the sheet "Impact", I want some code to toggle the hiding of rows 1-15.
I have a button which I want to assign the macro to.

If rows 1-15 are already hidden, I want to unhide them.
If rows 1-15 are visible, I want to hide them.

Any ideas? Otherwise it'll be 2 buttons!! Thanks

 

[steve the fish]

Try:

Rows("1:15").Hidden = Not Rows("1:15").Hidden

 

[ma0ffst08]

Try:

Rows("1:15").Hidden = Not Rows("1:15").Hidden

Hi Steve,
I've pasted that in as the entirety of my macro code, but doesn't seem to do anything?

 

[steve the fish]

So your code should just have this line, yes? Have you assigned it to a button on the sheet you want to toggle?

 

[ma0ffst08]

Hi Steve,
I've pasted that in as the entirety of my macro code, but doesn't seem to do anything?

Hi sorry, it does hide the rows.

I have slicers in these rows though, which don't hide.

Any idea how to toggle these to hide/unhide?