| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add a scroll bar from tool box into an Excel document
I am creating a document with a timeline and want to be able to use a scroll
bar along the dates. I have seen these used in Gantt charts. I have found the option by right clicking on the tool bars and then selecting control toolbox. A tool bar comes up with the option to select a scroll bar. Once I add it to my document it won't slide. I don't know how to connect it to the dates below. Can anyone help me? Many thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I add a scroll bar from tool box into an Excel document
You might find the scroll bar from the Forms toolbar works better on a
worksheet. After you add it, right click it and pick Format Control. On the Control tab you can link the scroll bar to a cell and set the increment, etc. -- Jim "Leeno" wrote in message ... |I am creating a document with a timeline and want to be able to use a scroll | bar along the dates. I have seen these used in Gantt charts. I have found | the option by right clicking on the tool bars and then selecting control | toolbox. A tool bar comes up with the option to select a scroll bar. Once I | add it to my document it won't slide. I don't know how to connect it to the | dates below. Can anyone help me? Many thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I add a scroll bar from tool box into an Excel document
Did you want a scroll bar or a slider. Be specific with the type of control
as there are a few that are similar. -- HTH... Jim Thomlinson "Leeno" wrote: I am creating a document with a timeline and want to be able to use a scroll bar along the dates. I have seen these used in Gantt charts. I have found the option by right clicking on the tool bars and then selecting control toolbox. A tool bar comes up with the option to select a scroll bar. Once I add it to my document it won't slide. I don't know how to connect it to the dates below. Can anyone help me? Many thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I add a scroll bar from tool box into an Excel document
Go to Stephen Bullen's site and download FunChrt7.xls
Demonstrates scroll and zoom using scroll bars. http://www.oaltd.co.uk/Excel/Default.htm Gord Dibben MS Excel MVP On Tue, 19 Aug 2008 09:18:13 -0700, Leeno wrote: I am creating a document with a timeline and want to be able to use a scroll bar along the dates. I have seen these used in Gantt charts. I have found the option by right clicking on the tool bars and then selecting control toolbox. A tool bar comes up with the option to select a scroll bar. Once I add it to my document it won't slide. I don't know how to connect it to the dates below. Can anyone help me? Many thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ANSWER: NEAT TOOL FOR HYPERLINK "DN" DOCUMENT. | Excel Discussion (Misc queries) | |||
| How to create a formatted 'readable' document based on Excel document? | Excel Discussion (Misc queries) | |||
| Why is the scroll bar way too big for my document? | Excel Worksheet Functions | |||
| I am missing view tool bar from tool menu. | New Users to Excel | |||
| Does anyone know if there is a tool to document Excel Spreadsheet. | Excel Discussion (Misc queries) | |||
Linear Mode
