follow hyperlink then de-select cell (VBA)

  • Thread starter Thread starter dgold82
  • Start date Start date
D

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!
 
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!
Click to expand...

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?
 
Back
Top