Hide n' show cells in protected sheet

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??
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hide columns on a protected sheet 2
Excel 2007 sheet and workbook protection 7
toolbar "button" for hiding/unhiding sheets 2
Hide Rows If Condition True 2
Change cell color in protected sheet 1
hiding an image 2
show or Hide cell comment when mouse hovers in Excel? 1
Page Protection interfering with Hiding Rows 3

Top