Re: Execute Macro automatically after hyperlink

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Jim Rech's code worked fine for me (xl2003) if I had a hyperlink that was
inserted via insert|hyperlink.

And you pasted the code under the work*** that held the hyperlinks, right?

Bill Elerding wrote:
>
> Whoops, Jim. The way it shows on the '*** 1 code' is:
>
> Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
> Application.Goto ActiveCell, True
> End Sub
>
> I had tried the option presented by Mr. Cone, also, with the same result. I
> guess it is a little late at night (midnight), and I'm doing something wrong
> if both approaches do not work for me. Thanks again, all!
>
> "Jim Rech" wrote:
>
> > Right click on the tab of the work*** with the hyperlinks and pick View
> > Code. In the module that appears paste this code:
> >
> > Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
> > Application.Goto ActiveCell, True
> > End Sub
> >
> > --
> > Jim
> > "Bill Elerding" <WElerding@xxxxxxxxxxxxxxxxx> wrote in message
> > news:98F72290-BE52-4F62-9B43-774DAF450328@xxxxxxxxxxxxxxxx
> > >I have set up hyperlinks in a table of contents that jumps to specific
> > > categories (individual cells) on the next work***. I'd like to have a
> > > macro execute automatically after the link to have that cell be situated
> > > at
> > > the upper left of the screen. I'm just beginning to get into macro's, and
> > > have not been able to figure this one out, even after checking other posts
> > > on
> > > this site. Thanks in advance!
> > > --
> > > William Elerding
> >
> >
> >

--

Dave Peterson
.

Quantcast