Thread: 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.

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

Hi Andy,
Thanks for the reply, but that doesn't work. The tool box becomes grayed
out.
CEC
"Andy Pope" <andy@andypope.info> wrote in message
news:eeWkjDNyFHA.2072@TK2MSFTNGP14.phx.gbl...
> 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

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" <andy@andypope.info> wrote in message
> news:eeWkjDNyFHA.2072@TK2MSFTNGP14.phx.gbl...
>
>>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

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" <andy@andypope.info> wrote in message
news:u2QbPrSyFHA.428@TK2MSFTNGP10.phx.gbl...
> 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" <andy@andypope.info> wrote in message
>> news:eeWkjDNyFHA.2072@TK2MSFTNGP14.phx.gbl...
>>
>>>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

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" <andy@andypope.info> wrote in message
> news:u2QbPrSyFHA.428@TK2MSFTNGP10.phx.gbl...
>
>>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" <andy@andypope.info> wrote in message
>>>news:eeWkjDNyFHA.2072@TK2MSFTNGP14.phx.gbl...
>>>
>>>
>>>>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