No problem having a macro run when you click in the cell, and picking
up the filename of the PDF file.

What I haven't found (in 20 minutes of looking) is a way to cause it to
print. If you can find a means by which Excel can cause it to print I
can help with the rest!

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup