Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What are the green triangles, in the upper left corner of a cell. | Excel Discussion (Misc queries) | |||
Scroll a cell to the top left hand corner of the screen | Excel Discussion (Misc queries) | |||
The 'X' in the upper right hand corner is suddenly dithered? Help | Excel Discussion (Misc queries) | |||
grey dot in left upper corner of cell | Excel Discussion (Misc queries) | |||
What does a small green triangle in the upper left hand corner of. | Excel Discussion (Misc queries) |