| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting HyperLinked Cell to Appear at the Top of the Screen
Thanks very much. Works like a charm!
"Tom Ogilvy" wrote in message ... right click on the sheet tab (with the hyperlink) and select View code. In the left dropdown, select worksheet. In the right dropdown select followhyperlink This will put the declaration for th event in the module. It has an argument target which is a hyperlink object. It will hold a reference to the hyperlink that triggered the event. Private Sub FollowHyperlink( Target as Hyperlink) msgbox Target.Range.Address End Sub will display the cell address of the hyperlink as an example. To position the target Private Sub FollowHyperlink( Target as Hyperlink) ActiveWindow.ScrollRow = ActiveCell.Row ActiveWindow.ScrollColumn = ActiveCell.column End Sub Worked for me. -- Regards, Tom Ogilvy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merging a hyperlinked cell with a non-hyperlinked cell? | Excel Discussion (Misc queries) | |||
| Setting hyperlinked cells to be displayed at the top of the screen | Excel Discussion (Misc queries) | |||
| bring hyperlinked cell to top of page | Excel Worksheet Functions | |||
| Want to click on 1 cell and have it hyperlinked to a highlighted c | Excel Worksheet Functions | |||
| How can I cause a cell which is hyperlinked to to display in bold. | Excel Worksheet Functions | |||
Threaded Mode
