unhide a row in a worksheet using vba
 

I have a command button that has this code already

Private Sub CommandButton1_Click()
Worksheets("Extra Earned Income Methd 1").Visible = True
End Sub

I would like to add an unhide of row 5 on sheet family totals.

Thanks
Roxy

unhide a row in a worksheet using vba
 

Sub CommandButton1_Click()
Worksheets("Extra Earned Income Methd 1").Visible = True
Worksheets("family totals").Range("A5").EntireRow.Hidden = False
End Sub



Gord Dibben MS Excel MVP

On Thu, 31 Jan 2008 15:49:01 -0800, Roxy wrote:

I have a command button that has this code already

Private Sub CommandButton1_Click()
Worksheets("Extra Earned Income Methd 1").Visible = True
End Sub

I would like to add an unhide of row 5 on sheet family totals.

Thanks
Roxy

unhide a row in a worksheet using vba
 

Your AWESOME! This works perffectly! Thank you so very much, have a
wonderful day!!

~Roxy

"Gord Dibben" wrote:

Sub CommandButton1_Click()
Worksheets("Extra Earned Income Methd 1").Visible = True
Worksheets("family totals").Range("A5").EntireRow.Hidden = False
End Sub



Gord Dibben MS Excel MVP

On Thu, 31 Jan 2008 15:49:01 -0800, Roxy wrote:

I have a command button that has this code already

Private Sub CommandButton1_Click()
Worksheets("Extra Earned Income Methd 1").Visible = True
End Sub

I would like to add an unhide of row 5 on sheet family totals.

Thanks
Roxy