LinkBack URL
About LinkBacks
Create a series of buttons within an Excel spreadsheet/form that when clicked the user is presented with the various other worksheets within the same workbook. It just opens up the one identified on the button and puts them on the first input cell.
Create a series of buttons within an Excel spreadsheet/form that when clicked the user is presented with the various other worksheets within the same workbook. It just opens up the one identified on the button and puts them on the first input cell.
Hi,
Welcome to the forum. You can insert buttons by "Insert" < Shapes. R click to add text. R click to select hyperlink. See attached example.
If I helped, please don't forget to add to my reputation. (click on the star below the post)
If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.
Failure is not falling down but refusing to get up.
I know you're asking for buttons, but if you're open to other methods then . . .
Option 1 - named range/cell method
On each sheet to which you want to navigate:
Select cell A1 > click into the Name Box (immediately left of formula bar) and enter the name of the sheet (no spaces).
Now the user simply selects the drop down arrow on the Name Box and selects the sheet and will be automatically take to the sheet/cell A1.
option 2 - built-in sheet navigation
If you are not aware, users can right-click on the on the navigation arrow in the left corner (adjacent to first sheet tab) and select a worksheet or choose More Sheets to get a scrolling list.
Last edited by Palmetto; 05-27-2012 at 09:55 PM.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
also, if you right click on the >| arrow at the bottom left of the sheet, (there are 4...<| < > |>) this will give you a list of all worksheets in that workbook. click on the 1 you want
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
That happens to be option-2 that I mentioned.if you right click on the >| arrow at the bottom left of the sheet
lol palmetto, 1 of these days i will read everything that is written, thx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks