macro to unhide row
 

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.

macro to unhide row
 

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.

macro to unhide row
 

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.

macro to unhide row
 

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.

macro to unhide row
 

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.