Hide/Unhide row in Excel 2003

[eXtremer]

Hi all.

How to make a button like "Filter" to hide or unhide a row ? Sometimes I may need that row sometimes not.
I know there is such an option, but I need it as a "click button".

Thank you in advance.

 

[PANKAJUTEKAR]

Hi,

See according to me, You can take two command buttons.
and following is the coding.

Private Sub CommandButton1_Click()
Selection.EntireRow.Hidden = True ........this is for hide
End Sub

Private Sub CommandButton2_Click()
Selection.EntireRow.Hidden = False .......this is for unhide
End Sub

 

[eXtremer]

Where the toggle button should appear ? Is it possible to locate it in the first column ?