code to center active cell on screen

[kosherboy]

Hi Excel Forum?
I found this code somewhere online that when you activate a sheet it will center the active cell in the middle of the screen.

Please Login or Register  to view this content.

However, this does not work when i click on a hyperlink that's on Sheet2 which refers to Sheet1. For some reason the code does not process the clicking-on-a-hyperlink as a method of activating the sheet.
Is there any way around this issue?
Any help will be greatly appreciated.

Thanks in advance

[PCI]

Try
Else send a sample of your file

Please Login or Register  to view this content.

[kosherboy]

Thanks PCI.
Just a couple little issues, your code is forcing the link to go to Sheet2/cell O22 instead of cell A22. And although your code did center the cell when i clicked on your link it did not center onto the cell when i click on a hyperlink formula.
See sample file CenterCell.xlsm

Thanks!

[PCI]

Try next code which seems working for an unknown reason (for me)

Please Login or Register  to view this content.

[kosherboy]

Thanks PCI. Unfortunately it's still not working for me