With a macro.

Sub hide_unhide()
ActiveSheet.Unprotect Password:="justme"
Rows("1:23").Hidden = True
ActiveSheet.Protect Password:="justme"
End Sub

Or possibly toggle

Sub toggle_hide_unhide()
ActiveSheet.Unprotect Password:="justme"
Rows("1:23").Hidden = Not Rows("1:23").Hidden
ActiveSheet.Protect Password:="justme"
End Sub


Gord Dibben MS Excel MVP


On Fri, 26 Oct 2007 13:29:01 -0700, Excellgreenhorn
wrote:

I need to show and hide rows in a protected sheet (2003), but I can't make it
happen. Is it possible at all in either 2003 or 2007??