Afternoon all,
Quick one for you to all,
I have a spreadsheet with multiple tabs and want to create a button that takes you to the next tab and one that will let you go back to the previous tab.
Now I did this originally by creating about 30 different small macros, however I'm sure there's an easier way to do this.
I can't use hyperlinks as they will show up when printing the report and I do not want that to happen.
Any help would be much appreciated.
Thanks all
Last edited by Taylor86; 07-23-2010 at 08:29 AM. Reason: spelling error
This functionality already exists in XL at the left bottom corner left of the sheet tabs
Hi,
That function does not take you to the next tab though, which is what I'm wanting to do.
Thanks for the responce though.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
I made this for you.
You could change the shape or position easily enough of the arrows.
Just put this code into the thisworkbook code.
Use the code from the next post.
Last edited by Everstrivin; 07-23-2010 at 09:20 AM.
If you can't figure out how a formula works, try stepping through it using "Evaluate Formula" in the Formula Auditing menu item in the tools menu!
If you want to see where your code went wrong, try stepping through it by clicking in the code and pressing F8 and watch as the magic happens!
If you are happy with any of the results, please add to the contributor's reputation by clicking the star icon.
something I wanted to add, but forgot was to delete the specific arrows.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks