Hyperlink target showing on top left corner of screen (Using image not cell)

Hi All,

Have a problem, hope you can help.

I'm trying to navigate through my worksheet with hyperlinks. When I click on the hyperlink the correct cell is activated, but is visible on the right side of the screen which meens I need to scroll to the right to see the contents of the section. When I click on the hyperlink I would like to see the target cell in the top left of the screen.

I've seen the following solution posted in many forums including this one but is not working for me.

Please Login or Register  to view this content.

This event macro seems to only get triggered if the hyperlink is contained within text in a cell as opposed to in an image/object. My hyperlinks consist of a series of flow charts which act as a navigation road map for the spreadsheet. Does anyone have any clue how to trigger this event macro if the hyperlink is contained in an image (box in a flow chart)?


Much Appreciated,
Mo

Hi Mo T and welcome to the forum

Instead of using VBA for the links, you could use this formula instead...

=IFERROR(HYPERLINK("#"&"'sheet1'!Aa100","this goes to sheet1 A1"),"")

The Code is working fine for me.

I believe you have wrongly pasted the code in Sheet Code Window instead of THISWORKBOOK code window

The reason is that the code is not running with Object since it is related to sheet event.

Add the below code's in Standard Module

Please Login or Register  to view this content.

Do right click on 1st object and select Remove Hyperlink and do it for the second one also.

Do right click on 1st object and select ASSIGN MACRO AND select ObjHyperlink1 and do it for the second one by assigning ObjHyperlink2.

Check the attached file for details.