Centering a hyperlink

[bagoxc]

This is probably pretty easy, but I've never done this and don't really feel like searching. I know lazy huh.

I have a hyperlink established between multiple names and where they sit on the call center floor. The links work, but I would like the result to be centered on the screen.

Any ideas?

Thanks in advance.

[martindwilson]

this macro will centre the active cell that you hyper link to

Please Login or Register  to view this content.

i take no credit i found it here
http://www.ozgrid.com/forum/showthread.php?t=56525
its not automatic so you'd have to assign it to run on a button click on tool bar