ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Putting scroll bars on chart sheet (https://www.excelbanter.com/charts-charting-excel/48424-putting-scroll-bars-chart-sheet.html)

Charles

Putting scroll bars on chart sheet
 
Hi,

Does anyone know if it is possible to add scroll bars onto a chart sheet?

Thanks for any suggestions.



Andy Pope

Hi,

You can add the scrollbar from the Forms toolbox, as opposed to the
Control toolbox.

Cheers
Andy

Charles wrote:
Hi,

Does anyone know if it is possible to add scroll bars onto a chart sheet?

Thanks for any suggestions.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Charles

Hi Andy,
Thanks for the reply, but that doesn't work. The tool box becomes grayed
out.
CEC
"Andy Pope" wrote in message
...
Hi,

You can add the scrollbar from the Forms toolbox, as opposed to the
Control toolbox.

Cheers
Andy

Charles wrote:
Hi,

Does anyone know if it is possible to add scroll bars onto a chart sheet?

Thanks for any suggestions.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info




Andy Pope

Are you sure that's the Forms toolbox? Use the menu View Toolbars to
see if the Forms one is active.

Charles wrote:
Hi Andy,
Thanks for the reply, but that doesn't work. The tool box becomes grayed
out.
CEC
"Andy Pope" wrote in message
...

Hi,

You can add the scrollbar from the Forms toolbox, as opposed to the
Control toolbox.

Cheers
Andy

Charles wrote:

Hi,

Does anyone know if it is possible to add scroll bars onto a chart sheet?

Thanks for any suggestions.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info





--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Charles

Hi Andy,

It worked, Thanks for the info. I didn't realize that their was a forms
toolbox. Do you know if any place where I can find info on connecting the
scroll control to the column of data properly. Thanks
"Andy Pope" wrote in message
...
Are you sure that's the Forms toolbox? Use the menu View Toolbars to see
if the Forms one is active.

Charles wrote:
Hi Andy,
Thanks for the reply, but that doesn't work. The tool box becomes grayed
out.
CEC
"Andy Pope" wrote in message
...

Hi,

You can add the scrollbar from the Forms toolbox, as opposed to the
Control toolbox.

Cheers
Andy

Charles wrote:

Hi,

Does anyone know if it is possible to add scroll bars onto a chart
sheet?

Thanks for any suggestions.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info





--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info




Andy Pope

If you right click the scrollbar and check the control tab most of the
setting are similar to the active-x scrollbar.

A google search may help.

Charles wrote:
Hi Andy,

It worked, Thanks for the info. I didn't realize that their was a forms
toolbox. Do you know if any place where I can find info on connecting the
scroll control to the column of data properly. Thanks
"Andy Pope" wrote in message
...

Are you sure that's the Forms toolbox? Use the menu View Toolbars to see
if the Forms one is active.

Charles wrote:

Hi Andy,
Thanks for the reply, but that doesn't work. The tool box becomes grayed
out.
CEC
"Andy Pope" wrote in message
...


Hi,

You can add the scrollbar from the Forms toolbox, as opposed to the
Control toolbox.

Cheers
Andy

Charles wrote:


Hi,

Does anyone know if it is possible to add scroll bars onto a chart
sheet?

Thanks for any suggestions.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info





--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 02:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com