VBA code to unhide rows with password

[Mohamed Taher]

Hi,

i need vba code to unhide range of rows with password in one sheet and rehide after closing the workbook.

thanks,

 

[Michael M]

Without further information, try

Sub MM1()
With ActiveSheet
    Unprotect Password:="YOURPASSWORD"
    .Cells.EntireRow.Hidden = False
    Protect Password:="YOURPASSWORD"
End With
End Sub