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.
|
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. |
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. |
All times are GMT +1. The time now is 10:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com