I'm looking to create a navigation sheet. Clicking different buttons will switch tabs and take you to the different parts of whichever sheet. Some sheets are several pages long so I thought this would be handy.
I tried using the hyperlink but it doesn't work as expected. It kind of randomly goes there. Ideally, I'd like the top of the page to be at the top of the screen. Make sense?
Last edited by jumonjii; 04-17-2014 at 07:14 PM.
Just to give you an idea, please find the attached sheet to see if this is what you want.
If you want to see the top of the page, you may change A100 to A1 in the code.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Yes, that seems to work. Took me a few tries to find the code. It's not a macro? So...if I wanted multiple buttons, how would that work?
This work?
That's really cool. So I can copy the code and change it as needed in the one macro then?
Yes, just edit the code for the page and range.
Rock on! Thanks alot.
You guys on this forum are fantastic! I still have trouble working out all the formulas and love that you folks are willing to explain it as best you can.
Mostly, if I can get it to work, I'm happy.
Thanks again!!
Apologies, just read your post again, macro for each button, edit the code for each button.
What I meant is that if I have 6 buttons, I don't need 6 macros correct? The one macro will have 6 'sub', 'end sub' sections?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks