Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 25th 08, 05:26 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 6
Default Hyperlink to cell and have it appear at top upper left hand corner

I am new user. I have created 3 worksheets and defined names for certain
cells. I have then created hyperlinks for those cells to go to other named
cells. My problem is that when I click on the hyperlinked cell, Excel goes
to the correct cell but I would like to have it appear at the top left corner
of the spreadsheet. It instead might appear at the middle or right hand side
of the spreadsheet. What can I do to correct this? Thank you in advance
for anyones response.

  #2   Report Post  
Old November 25th 08, 08:26 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 210
Default Hyperlink to cell and have it appear at top upper left hand corner

There must be a better way, but I would programatically check the left & top
values of the cell and move a temporary cursor right & down until the
original cell was as close to zero on the left & top as possible.
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"Bisonhawk" wrote:

I am new user. I have created 3 worksheets and defined names for certain
cells. I have then created hyperlinks for those cells to go to other named
cells. My problem is that when I click on the hyperlinked cell, Excel goes
to the correct cell but I would like to have it appear at the top left corner
of the spreadsheet. It instead might appear at the middle or right hand side
of the spreadsheet. What can I do to correct this? Thank you in advance
for anyones response.

  #3   Report Post  
Old November 25th 08, 08:56 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 6
Default Hyperlink to cell and have it appear at top upper left hand co

I'm not sure how I would go about doing that. I also have some defined names
with hyperlinks on the same sheet. Example: Cell A100 links to AA2. When I
click on A100, it takes me to AA2 but it is clear to the right of the screen.

"galimi" wrote:

There must be a better way, but I would programatically check the left & top
values of the cell and move a temporary cursor right & down until the
original cell was as close to zero on the left & top as possible.
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"Bisonhawk" wrote:

I am new user. I have created 3 worksheets and defined names for certain
cells. I have then created hyperlinks for those cells to go to other named
cells. My problem is that when I click on the hyperlinked cell, Excel goes
to the correct cell but I would like to have it appear at the top left corner
of the spreadsheet. It instead might appear at the middle or right hand side
of the spreadsheet. What can I do to correct this? Thank you in advance
for anyones response.

  #4   Report Post  
Old November 26th 08, 03:40 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default Hyperlink to cell and have it appear at top upper left hand co

If you are hyperlinking between cells on the same sheet, Insert this tiny
event macro in the worksheet code area:

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

This will not work with hyperlinks created by functions.


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 - gsnu200816


"Bisonhawk" wrote:

I'm not sure how I would go about doing that. I also have some defined names
with hyperlinks on the same sheet. Example: Cell A100 links to AA2. When I
click on A100, it takes me to AA2 but it is clear to the right of the screen.

"galimi" wrote:

There must be a better way, but I would programatically check the left & top
values of the cell and move a temporary cursor right & down until the
original cell was as close to zero on the left & top as possible.
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"Bisonhawk" wrote:

I am new user. I have created 3 worksheets and defined names for certain
cells. I have then created hyperlinks for those cells to go to other named
cells. My problem is that when I click on the hyperlinked cell, Excel goes
to the correct cell but I would like to have it appear at the top left corner
of the spreadsheet. It instead might appear at the middle or right hand side
of the spreadsheet. What can I do to correct this? Thank you in advance
for anyones response.

  #5   Report Post  
Old December 4th 08, 04:05 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 6
Default Hyperlink to cell and have it appear at top upper left hand co

Thank you very much for the information. I applied this macro to my
worksheet and it works GREAT!

"Gary''s Student" wrote:

If you are hyperlinking between cells on the same sheet, Insert this tiny
event macro in the worksheet code area:

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

This will not work with hyperlinks created by functions.


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 - gsnu200816


"Bisonhawk" wrote:

I'm not sure how I would go about doing that. I also have some defined names
with hyperlinks on the same sheet. Example: Cell A100 links to AA2. When I
click on A100, it takes me to AA2 but it is clear to the right of the screen.

"galimi" wrote:

There must be a better way, but I would programatically check the left & top
values of the cell and move a temporary cursor right & down until the
original cell was as close to zero on the left & top as possible.
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"Bisonhawk" wrote:

I am new user. I have created 3 worksheets and defined names for certain
cells. I have then created hyperlinks for those cells to go to other named
cells. My problem is that when I click on the hyperlinked cell, Excel goes
to the correct cell but I would like to have it appear at the top left corner
of the spreadsheet. It instead might appear at the middle or right hand side
of the spreadsheet. What can I do to correct this? Thank you in advance
for anyones response.



  #6   Report Post  
Old December 4th 08, 08:16 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default Hyperlink to cell and have it appear at top upper left hand co

You are very welcome!
--
Gary''s Student - gsnu200817


"Bisonhawk" wrote:

Thank you very much for the information. I applied this macro to my
worksheet and it works GREAT!

"Gary''s Student" wrote:

If you are hyperlinking between cells on the same sheet, Insert this tiny
event macro in the worksheet code area:

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

This will not work with hyperlinks created by functions.


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 - gsnu200816


"Bisonhawk" wrote:

I'm not sure how I would go about doing that. I also have some defined names
with hyperlinks on the same sheet. Example: Cell A100 links to AA2. When I
click on A100, it takes me to AA2 but it is clear to the right of the screen.

"galimi" wrote:

There must be a better way, but I would programatically check the left & top
values of the cell and move a temporary cursor right & down until the
original cell was as close to zero on the left & top as possible.
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"Bisonhawk" wrote:

I am new user. I have created 3 worksheets and defined names for certain
cells. I have then created hyperlinks for those cells to go to other named
cells. My problem is that when I click on the hyperlinked cell, Excel goes
to the correct cell but I would like to have it appear at the top left corner
of the spreadsheet. It instead might appear at the middle or right hand side
of the spreadsheet. What can I do to correct this? Thank you in advance
for anyones response.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What are the green triangles, in the upper left corner of a cell. Humber Excel Discussion (Misc queries) 3 October 4th 06 02:35 PM
Scroll a cell to the top left hand corner of the screen Daveh Excel Discussion (Misc queries) 2 August 30th 06 05:17 PM
The 'X' in the upper right hand corner is suddenly dithered? Help Vicki P Excel Discussion (Misc queries) 3 May 13th 06 12:41 AM
grey dot in left upper corner of cell singnothing Excel Discussion (Misc queries) 1 April 1st 06 10:06 AM
What does a small green triangle in the upper left hand corner of. Fleas32 Excel Discussion (Misc queries) 3 December 29th 04 07:07 PM


All times are GMT +1. The time now is 12:41 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017