Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create buttons to link worksheets within a workbook?
E.g. Creat a list of buttons/links on Sheet1 to take me directly to Sheet2.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create buttons to link worksheets within a workbook?
Hi,
Click View|Toolbars|forms Click the button icon on the toolbar Put the cursor over the worksheet where you want the button and drag the button to the size you want When you relaease the mouse button a dialogue will pop up Click New Enter the code Sheets("Sheet2").select click the red cross to close VB editor Click your button Mike "kay505" wrote: E.g. Creat a list of buttons/links on Sheet1 to take me directly to Sheet2. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create buttons to link worksheets within a workbook?
You can use the right-click on the navigation arrows or build a Navigation
Toolbar as per Dave's code on Debra Dalgleish's site. http://www.contextures.on.ca/xlToolbar01.html Or see this google search thread for the BrowseSheets macro from Bob Phillips. http://tinyurl.com/yoa3dw I'm kinda partial to Bob's method. Gord Dibben MS Excel MVP On Wed, 5 Mar 2008 02:36:01 -0800, kay505 wrote: E.g. Creat a list of buttons/links on Sheet1 to take me directly to Sheet2. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create header/footer txt file and link to Excel worksheets | Excel Programming | |||
Create header/footer txt file and link to Excel worksheets | Excel Discussion (Misc queries) | |||
how to create buttons which point to other worksheets? | Excel Discussion (Misc queries) | |||
how do I link worksheets in the same workbook? | Excel Worksheet Functions | |||
Link multiple worksheets in one workbook to another workbook and . | Excel Programming |