VBA button that changes label when click ie. expand, collapse

Hi Guys,

Ive got some code which will toggle hide and unhide rows, thats fine.

Sub transaction1()
Rows("7:9").Hidden = Not Rows("7:9").Hidden
End Sub

How ever I would like the macro button to change labels when clicked. Ie Expand when hidden and Collapse when unhidden.

Can you help please ?
Ive search high and low and although simple cannot find a direct answer.

Originally Posted by TMShucks

I use this code to hide or show some worksheets:

Please Login or Register  to view this content.

Use the button's caption to indicate its state. If, when you press it, it says "hide", you hide the rows and set it to "show".

Regards, TMS

_________________


Hi Thanks for the quick response. I couldn't get it to work unfortunately. I'm just a beginner at VBA atm. Do you post the code in a module? Can you advise how I can assign the button to it. Sorry for being a noob.

I just need it to hide and unhide certain rows (from a button) when the button is clicked I want the button to be named "collapse" to hide the rows and when clicked again to be named "expand"

thanks again