| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repositioning after hyperlink.....
On Tuesday, April 21, 1998 3:00:00 AM UTC-4, Richard Meimoun wrote:
Hi there ! I've made a hyperlink on D1 and is pointing to A200 but on the same sheet. My question is how can I make the cell A200 the top left corner of my sheet ? Thanx in advance. Use the FollowHyperLink event on the sheet with the hyperlink Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) ActiveWindow.ScrollColumn = ActiveCell.Column ActiveWindow.ScrollRow = ActiveCell.Row End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Still Need Help Repositioning Comments | Excel Programming | |||
| Repositioning cursor | Excel Programming | |||
| Repositioning a cell based on its value | Excel Discussion (Misc queries) | |||
| Repositioning a cell based on its value | Excel Worksheet Functions | |||
| Repositioning the tabs | Excel Worksheet Functions | |||
Linear Mode
