Show/Hide button - vba macro - List

Greetings everybody,

I want to do a list of items with subitems. For that I created a button that can show/hide lines under it by clicking. I want to do something like this in excel:

http://codeblitz.wordpress.com/2009/...lapsible-list/

It already works with the macro exposed in the end, and it reads the value of the right side neighbor cell for vba knows how many lines its going to be hidden.

My problem is that when I have a button in line 10, for example, and I want to hide lines from 11 to 20, i can not hide any buttons that might be on those lines. When i click the button at line 10, any button on line 11 to 20 goes to line 21 right under the line 10.

Does anybody know a way of fixing it by hiding the button(s) together with the hidden lines OR another way of doing this list???

Remember that my button can be copy/paste to any cell and still hide any number of lines under it by reading the righside cell.

Well...thanks in advance for any help!

JS5

Please Login or Register  to view this content.

Cross-posted at VBAExpress http://www.vbaexpress.com/forum/showthread.php?t=35479, and Xtreme VBTalk http://www.xtremevbtalk.com/showthread.php?t=319676, and maybe elsewhere.

ok! didnt know i am not able to post in other foruns!! sorry!!

well... can u help with my problem?

thnx
JS5