Macro to hide rows.

Is it always row5 that you want hidden?

redasin,

Welcome to the forum!
Give this a try:

Sub tgr()
    
    Dim ws As Worksheet
    For Each ws In ActiveWorkbook.Sheets
        ws.Rows(5).Hidden = True
    Next ws
    
End Sub

Hi

Sub HideRowFive()
    Dim ws As Worksheet
    For Each ws In ActiveWorkbook.Sheets
        ws.Rows(5).Hidden = True
    Next ws
End Sub

Hi redasin,

Welcome to the forum.
Below is a quick code which can be used:-

Sub hide()

    For Each Sheet In ActiveWorkbook.Sheets

    Rows(5).Hidden = True

    On Error Resume Next
    ActiveSheet.Next.Select
    Next

End Sub

Regards,
DILIPandey

<click on below 'star' if this helps>