follow hyperlink then de-select cell (VBA)

[dgold82]

I have a bunch of hyperlinks scattered throughout an excel application
that I developed. We are having one little aesthetic problem--the cell
select border (the black border excel puts around an active cell).

Is there a way to programicly de-select a select once the link has
been followed? I have been looking for an activate_hyperlink type of
macro but can't find anything.

My first questions were about trying to remove the border entirely but
I was thinking that if there was some type of VBA code that controls
the way hyperlinks work once clicked--it could be as simple as just
following the hyperlink (which selects the target cell) and then just
de-select.

Any ideas or examples of code? Thank!

 

[dgold82]

I have a bunch of hyperlinks scattered throughout an excel application
that I developed. We are having one little aesthetic problem--the cell
select border (the black border excel puts around an active cell).

Is there a way to programicly de-select a select once the link has
been followed? I have been looking for an activate_hyperlink type of
macro but can't find anything.

My first questions were about trying to remove the border entirely but
I was thinking that if there was some type of VBA code that controls
the way hyperlinks work once clicked--it could be as simple as just
following the hyperlink (which selects the target cell) and then just
de-select.

Any ideas or examples of code? Thank!

Alternatively, perhaps once the hyperlink is followed a far off cell
is then selected off the screen (without moving the view). How can I
globally do that for all my hyperlinks?