Dear Benjamin
Try using the .Hyperlinks method of the worksheet object. The folowing
will create a hyperlink to a PowerPoint presentation in the activecell.
You do not need the SubAddress and if the ScreenTi is left empty it will
display the full path of the presentation:-
ActiveSheet.Hyperlinks.Add _
Anchor := ActiveCell, _
Address := "<<file path of presentation", _
SubAddress := "", _
ScreenTip := "", _
TextToDisplay := "<<text displayed in the cell"
Hope it helps
Sean
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!