Hide Scrolling Table Scrollbar when Group Collapsed

I have a scrolling table using a vertical scrollbar. I have the table grouped so I can expand/collapse it to be shown/hidden, however, when I collapse it, the scrollbar is still shown.

Is there a way to programtically or non programatically hide the vertical scrollbar when the table is collapsed (hidden) and reshow it when the table is expansed (shown)?

So, I just ended up using an Active X scrollbar instead as this does exactly the same thing and can be hidden when a group of cells is collapsed...

Hi,

Can u please suggest how did u manage to create a scrolling table as i too need some help on the same.

Appreciate your assistance.

Thanks!

Cheers,
SS

Hi bokishai,

This link shows how to do this step by step...

http://chandoo.org/wp/2008/08/20/cre...oards-excel-1/

I hope that helps... it explains it better than I could...