Post a PDF in a cell text box or similar

[razorexcel]

How can I post a PDF file so that if a cell is highlighted that the PDF file with pop up? If their is a similar method that I'm not thinking of, I'm open to ideas.

 

[Andrew Poulsom]

Welcome to the Board.

Have you tried Insert|Hyperlink then Browse for File?

 

[razorexcel]

would I be able to email that to someone and they could pull up the PDF?

 

[Andrew Poulsom]

Only if they had access to the file's path. Another option is Insert|Object, checking Display as icon.

 

[Mr. Walnuts]

You can Add an Object (Adobe Acrobat File) on a worksheet in the document (preferably very far down on the sheet, out of sight.

Wherever you want the link, insert hyperlink to... then select "place in this document"... then select the sheet the PDF file is located... then where it says, cell reference, enter the cell nearest the top of the document on the sheet where it is located.

this will create a hyperlink to the PDF object that is stored INSIDE the workbook you're sending.

**Note**
This makes for very large workbooks though because your PDF is stored inside the workbook. If you're hyperlinking more than 1 PDF, I recommend storing all of them on a single worksheet with "display as icon" checked to save space as mentioned above. Than they can doubleclick the one they need; bummer you can't hide the sheet though.

 

[razorexcel]

Thanks, the objects one was great!.