Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Window Movement
If I activate a hyperlink on one sheet to a cell on another sheet, the target
cell is shown in the lower right corner of the window. How can I make the window display the active cell in the top left of the window? I had considered using the activate sheet event to control the screen movement but how do I determien the scroll required? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Window Movement
Nigel RS wrote:
If I activate a hyperlink on one sheet to a cell on another sheet, the target cell is shown in the lower right corner of the window. How can I make the window display the active cell in the top left of the window? I had considered using the activate sheet event to control the screen movement but how do I determien the scroll required? Thanks Hi, Try this code in the code module of either the sheet with the hyperlink of the sheet the hyperlink takes the user to.. Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) With ActiveWindow ..ScrollRow = ActiveCell.Row ..ScrollColumn = ActiveCell.Column End With End Sub Ken Johnson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Window Movement
Works Great
Thanks "Ken Johnson" wrote: Nigel RS wrote: If I activate a hyperlink on one sheet to a cell on another sheet, the target cell is shown in the lower right corner of the window. How can I make the window display the active cell in the top left of the window? I had considered using the activate sheet event to control the screen movement but how do I determien the scroll required? Thanks Hi, Try this code in the code module of either the sheet with the hyperlink of the sheet the hyperlink takes the user to.. Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) With ActiveWindow ..ScrollRow = ActiveCell.Row ..ScrollColumn = ActiveCell.Column End With End Sub Ken Johnson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Window Movement
You're welcome Nigel. Thanks for the feedback. Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to save a desired window size but hv window comeup fullsz by d | Excel Discussion (Misc queries) | |||
View cell contents as a pop-up window (similar to comments window) | Excel Worksheet Functions | |||
Docking Project Explorer, Properties window and Code window in VBE | Setting up and Configuration of Excel | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
In Excel - how to delete new window created from window on tool ba | Excel Worksheet Functions |