View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.programming
huntermcg[_23_] huntermcg[_23_] is offline
external usenet poster
 
Posts: 1
Default hide rows with macro/togglebutton


hi.

i have another question wich you could help me with.

now the code is something like:
Sub VerbergenOP1FA()
ActiveSheet.Unprotect Password:="xyz"
Rows("7:13").Hidden = Not Rows("7:13").Hidden
ActiveSheet.Protect Password:="xyz"
End Sub

This code opens the rows and close them. now i want when i open the
rows not to show all. for instance alone the rows 7:8 and 12:13. How do
I adjust this in the VBA code.

Please help.


--
huntermcg
------------------------------------------------------------------------
huntermcg's Profile: http://www.excelforum.com/member.php...o&userid=19391
View this thread: http://www.excelforum.com/showthread...hreadid=469683