Hide n' show cells in protected sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
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
 
Back
Top