In Excel 2007, I am doing a publications catalogue listing books according to
categories and books details. I select a range of cells which I name, using
name
manager, ie for name ref192671729 the value is "Dermatology in Chinese
Medicine" and it refers to ='Publications Review'!$A$151:$E$155. Then in the
index I select the book and I hyperlink it to a place in that document with
that reference 192671729. Then when I click on this book title in the index it
makes it appear at the bottom of the screen. Is there any way of making it
appear
at the top left of the screen?

Install this event macro in the worksheet code area:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Application.Goto reference:=ActiveCell, scroll:=True
End Sub


Because it is worksheet code, it is very easy to install and use:

1. right-click the tab name near the bottom of the window
2. select View Code - this brings up a VBE window
3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To remove the macro:

1. bring up the VBE windows as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

To learn more about Event Macros (worksheet code), see:

http://www.mvps.org/dmcritchie/excel/event.htm


--
Gary''s Student - gsnu200817


"Elisabeth" wrote:

In Excel 2007, I am doing a publications catalogue listing books according to
categories and books details. I select a range of cells which I name, using
name
manager, ie for name ref192671729 the value is "Dermatology in Chinese
Medicine" and it refers to ='Publications Review'!$A$151:$E$155. Then in the
index I select the book and I hyperlink it to a place in that document with
that reference 192671729. Then when I click on this book title in the index it
makes it appear at the bottom of the screen. Is there any way of making it
appear
at the top left of the screen?

Many thanks Gary, it works wonders, you re a star!
Kind regards,
Elisabeth

"Gary''s Student" wrote:

Install this event macro in the worksheet code area:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Application.Goto reference:=ActiveCell, scroll:=True
End Sub


Because it is worksheet code, it is very easy to install and use:

1. right-click the tab name near the bottom of the window
2. select View Code - this brings up a VBE window
3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To remove the macro:

1. bring up the VBE windows as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

To learn more about Event Macros (worksheet code), see:

http://www.mvps.org/dmcritchie/excel/event.htm


--
Gary''s Student - gsnu200817


"Elisabeth" wrote:

In Excel 2007, I am doing a publications catalogue listing books according to
categories and books details. I select a range of cells which I name, using
name
manager, ie for name ref192671729 the value is "Dermatology in Chinese
Medicine" and it refers to ='Publications Review'!$A$151:$E$155. Then in the
index I select the book and I hyperlink it to a place in that document with
that reference 192671729. Then when I click on this book title in the index it
makes it appear at the bottom of the screen. Is there any way of making it
appear
at the top left of the screen?

Hi Gary,

As we are also going to give this catalogue to practitioners who are working
with older versions of Excel (97-2003), is there a makro available or some
similar option for those older versions please?

Elisabeth

"Gary''s Student" wrote:

Install this event macro in the worksheet code area:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Application.Goto reference:=ActiveCell, scroll:=True
End Sub


Because it is worksheet code, it is very easy to install and use:

1. right-click the tab name near the bottom of the window
2. select View Code - this brings up a VBE window
3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To remove the macro:

1. bring up the VBE windows as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

To learn more about Event Macros (worksheet code), see:

http://www.mvps.org/dmcritchie/excel/event.htm


--
Gary''s Student - gsnu200817


"Elisabeth" wrote:

In Excel 2007, I am doing a publications catalogue listing books according to
categories and books details. I select a range of cells which I name, using
name
manager, ie for name ref192671729 the value is "Dermatology in Chinese
Medicine" and it refers to ='Publications Review'!$A$151:$E$155. Then in the
index I select the book and I hyperlink it to a place in that document with
that reference 192671729. Then when I click on this book title in the index it
makes it appear at the bottom of the screen. Is there any way of making it
appear
at the top left of the screen?

It should work on older versions of Excel, not sure about Excel 97
--
Gary''s Student - gsnu200817


"Elisabeth" wrote:

Hi Gary,

As we are also going to give this catalogue to practitioners who are working
with older versions of Excel (97-2003), is there a makro available or some
similar option for those older versions please?

Elisabeth

"Gary''s Student" wrote:

Install this event macro in the worksheet code area:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Application.Goto reference:=ActiveCell, scroll:=True
End Sub


Because it is worksheet code, it is very easy to install and use:

1. right-click the tab name near the bottom of the window
2. select View Code - this brings up a VBE window
3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To remove the macro:

1. bring up the VBE windows as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

To learn more about Event Macros (worksheet code), see:

http://www.mvps.org/dmcritchie/excel/event.htm


--
Gary''s Student - gsnu200817


"Elisabeth" wrote:

In Excel 2007, I am doing a publications catalogue listing books according to
categories and books details. I select a range of cells which I name, using
name
manager, ie for name ref192671729 the value is "Dermatology in Chinese
Medicine" and it refers to ='Publications Review'!$A$151:$E$155. Then in the
index I select the book and I hyperlink it to a place in that document with
that reference 192671729. Then when I click on this book title in the index it
makes it appear at the bottom of the screen. Is there any way of making it
appear
at the top left of the screen?