hello,

I want to be able to hide and unhide rows by clicking a togglebutton.

So far, I managed to record 2 macro's. 1 to hide the rows and 1 t
unhide the rows. I could make to button's to assign each macro to, bu
that would be a lot of work, since I want to add this function t
several places in my worksheet.

A togglebutton would do the trick, but I do not know how to assign th
2 macro's to it. Is there any pro out there who could help me out ?

At least I think the toggle button would be in my humble opinion th
best solution. The only thing is that I have to put the togglebutto
somewhere outside the rows I wish to hide/unhide. If there is a bette
solution thinkable I am happy to hear ?

Next to this, I protect my sheets. With the 2 button's I managed to fi
myself I get a 'false' error when I protect my sheet. I am not sure wha
I am doing wrong

--
huntermc
-----------------------------------------------------------------------
huntermcg's Profile: http://www.excelforum.com/member.php...fo&userid=1939
View this thread: http://www.excelforum.com/showthread.php?threadid=46968