Hiding a ScrollBar

**Mordred** · 02-23-2011, 11:52 AM

Hi all,

I am trying to fine tune a charting tool but Excel is acting odd, or I am odd, or both

. Whatever the case may be, if you fill the charts with data using the buttons, click the top chart to zoom the view size, use the scroll bar, and then click the top chart again to zoom the view size back to 75, the scroll bar will not hide (unless you click the chart again, and then again).
Within the module ChartClick, I have the following code:

Please Login or Register  to view this content.

Does something here look off? Perhaps, while I am thinking about it, is it a sequential code reading issue? I don't know but if someone has an idea, I would love to here it! Thanks so much

**Mordred** · 02-23-2011, 11:59 AM

Well, its has nothing to do with sequential code reading.

**Andy Pope** · 02-23-2011, 12:32 PM

Try adding a DoEvents line after chaning the visible properties of the scrollbars.

Please Login or Register  to view this content.

**Mordred** · 02-23-2011, 12:36 PM

Thanks Andy, but no changes.

**Andy Pope** · 02-23-2011, 12:49 PM

My bad, I did not actually use the scroller to adjust the chart before zooming out. When I did I could replicate the problem.

Try this instead.

Please Login or Register  to view this content.

**Mordred** · 02-23-2011, 12:58 PM

I cannot express how much I appreciate your help with this, off and on throughout the creation of this charting tool. Your suggestion worked perfectly. Thanks again.