button with hyperlink properties
 

Hello

I would like to insert a button inside a worksheet which has th
ability to open a file folder.
We do not want to open the file in excel but in its origina
programme.
For instance looking up a pdf-file in that folder and opening it i
acrobat reader.
We also do NOT want a button in the toolbar.

I know this is possible by a normal hyperlink but is it also possibl
to integrate a hyperlink inside the button.

All replies are very welcome. Thanks.
Pau

--
pvanrooije
-----------------------------------------------------------------------
pvanrooijen's Profile: http://www.excelforum.com/member.php...fo&userid=2609
View this thread: http://www.excelforum.com/showthread.php?threadid=39418

button with hyperlink properties
 

Hi
use the following in the object event.
ThisWorkbook.FollowHyperlink "C;\Temp\test.doc"
Regards
JY
"pvanrooijen"
wrote in message
...

Hello

I would like to insert a button inside a worksheet which has the
ability to open a file folder.
We do not want to open the file in excel but in its original
programme.
For instance looking up a pdf-file in that folder and opening it in
acrobat reader.
We also do NOT want a button in the toolbar.

I know this is possible by a normal hyperlink but is it also possible
to integrate a hyperlink inside the button.

All replies are very welcome. Thanks.
Paul


--
pvanrooijen
------------------------------------------------------------------------
pvanrooijen's Profile:
http://www.excelforum.com/member.php...o&userid=26090
View this thread: http://www.excelforum.com/showthread...hreadid=394183