Hyperlink to cell

[iwchameleon]

I have a workbook with hlinks to named locations throughout. I would like to know if the destination cell be forced to appear to the top left corner of the worksheet view?

Thanks for any help

Mike

[rylo]

Mike

One thing you could do is have a selection_change event to make this happen.

Please Login or Register  to view this content.

The code as it stands will make the currently selected cell the top left cell. You may want to restrict this to only apply to certain entries. You could restrict it to certain destination address

Please Login or Register  to view this content.

or a range of addresses

Please Login or Register  to view this content.

HTH

rylo

[Leith Ross]

Hello Mike,

Install this macro to place any cell called by a hyperlink in the upper left corner of the screen.

Please Login or Register  to view this content.

How to Save a Workbook Event Macro
1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on any Worksheet's Name Tab
3. Left Click on View Code in the pop up menu.
4. Press ALT+F11 keys to open the Visual Basic Editor.
5. Press CTRL+R keys to shift the focus to the Project Explorer Window
6. Press the Down Arrow Key until ThisWorkbook is highlighted in blue.
7. Press the Enter key to move the cursor to the Code Window
8. Paste the macro code using CTRL+V
9. Save the macro in your Workbook using CTRL+S

Sincerely,
Leith Ross

[rylo]

Leith

nice.....

rylo