Same button to reverse macro VBA

[ALAMZEB]

Hi
Can I use same button to reverse macro
In attached example, if I click HIDE button it hides, but want to unhide if Its clicked again.
Much appreciates
Thanks in advance

 

[Smallman]

Hi Alamzeb

Change the button to a command button. This makes the coding a bit more straight forward. Named the commandbutton cbB1.

Private Sub cmdB1_Click()
    If cmdB1.Caption = "Unhide" Then
      Rows("7:16").EntireRow.Hidden = False
      cmdB1.Caption = "Hide"
    Else: Rows("7:16").EntireRow.Hidden = True
      cmdB1.Caption = "Unhide"
  End If
End Sub

File attached to show workings.

Take care

Smallman

 

[ALAMZEB]

Hi small man

have you attached the file because i cant find it

 

[Smallman]

I have now attached it above.

 

[ALAMZEB]

Thanks Small man.. it works great

 

[Smallman]

No problem Alamzeb

Take care

Smallman