Could someone help me with some code to unhide the first row of a worksheet?
Ideally I would like to attach to a button.

Thank You.

Have you tried recording a macro while doing this manually

--
Don Guillett
SalesAid Software

"Benjamin" wrote in message
...
Could someone help me with some code to unhide the first row of a
worksheet?
Ideally I would like to attach to a button.

Thank You.

I'll give that a try. Thanks.

"Don Guillett" wrote:

Have you tried recording a macro while doing this manually

--
Don Guillett
SalesAid Software

"Benjamin" wrote in message
...
Could someone help me with some code to unhide the first row of a
worksheet?
Ideally I would like to attach to a button.

Thank You.

Hi Benjamin

Sub test()
With Sheets("sheet1")
.Range("A1").EntireRow.Hidden = False
End With
End Sub

You can assign this macro to a Button from the Forms Toolbar if you want

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Benjamin" wrote in message ...
Could someone help me with some code to unhide the first row of a worksheet?
Ideally I would like to attach to a button.

Thank You.

If you want an hidden/unhidden macro, this will work.

Sub HideUnhideRow()
If Range("A1").EntireRow.Hidden = True Then Range("A1").EntireRow.Hidden =
False Else: Range("A1").EntireRow.Hidden = True
End Sub

May not be the best way, but gets the job done.
HTH,
Paul

"Benjamin" wrote in message
...
Could someone help me with some code to unhide the first row of a
worksheet?
Ideally I would like to attach to a button.

Thank You.