From: Dave Peterson on
ps.

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

You'll have to add something that unprotects the sheet near the beginning and
reprotects the sheet at the end.

JJ wrote:
>
> Dave
> can you guide me as to hyperlink with a macro as this seems to be the better
> option. I am not good with macros.
>
> tx
>
> "Dave Peterson" wrote:
>
> > Or maybe you could replace the hyperlink with a macro that opens both .pdf
> > files???
> >
> > Or (untested), you could hyperlink to a .bat or .vbs file that runs and opens
> > both files.
> >
> > JJ wrote:
> > >
> > > Hi
> > >
> > > How do I hyperlink a cell to more than one PDF files?
> > >
> > > Thanks
> > >
> > > JJ
> >
> > --
> >
> > Dave Peterson
> > .
> >

--

Dave Peterson