Hyer link help
I am designing a spreadsheet. My sheet is very wide by design. I want to make hyper links to jump to the section of the page I want to see. I need the section to “jump” to the far left side of the program screen not to the middle of the screen. I installed Hyper links on my spreadsheet when I click to them, the section of the page shows up in the middle of the screen. How do I make this happen?
Thanks
Gary
Hello Garydaw,
You need to create a macro to scroll side to side and up and down. Here is an example that will put the cell you choose in the Top Left corner. You can change the Row and Column to match where you want to move the worksheet. This example puts cell AV15 in the top left corner.
You can place buttons on your worksheet then attach this macro to them. Just be sure to copy the macro, give it a different name, and change the address before assigning it to another button to position the worksheet.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Last edited by Leith Ross; 02-26-2007 at 12:40 AM.
Leith,
Unless you can give me instructions on how to do this I am lost. This is way over my head... I tried to figure it out, I seriously don't have a clue to where and how to start..... Is there a simple way to do this?
Thanks,
Gary
This could work
on the sheet with the hyperlink
right click on the sheet tab and select view codes
copy and paste this code in the area
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