220coupe
03-26-2009, 08:09 AM
Hi, first post here - i have tried searching but cant find what i need.
I am using excel 2007 in compatability mode as the end recipients are using 2003.
I have created a work book and on the first page I have a table of hyperlinks that link to several named ranges in a second sheet. What I am looking to do is, when ever a link is followed, the named range is positioned as though it it was in A1. The ranges for the cells are only one cell in size, and are across row 1, underneath each of the ranges are pivot tables. So for example the following cells are named ranges a1, w1, aa1, ac1. when a user selects the link for AC1 i want AC1 to be in the top left corner of the excel window.
Hope you can help.
Thanks in advance.
I am using excel 2007 in compatability mode as the end recipients are using 2003.
I have created a work book and on the first page I have a table of hyperlinks that link to several named ranges in a second sheet. What I am looking to do is, when ever a link is followed, the named range is positioned as though it it was in A1. The ranges for the cells are only one cell in size, and are across row 1, underneath each of the ranges are pivot tables. So for example the following cells are named ranges a1, w1, aa1, ac1. when a user selects the link for AC1 i want AC1 to be in the top left corner of the excel window.
Hope you can help.
Thanks in advance.