razorexcel
New Member
- Joined
- Mar 4, 2009
- Messages
- 3
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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Post a PDF in a cell text box or similar
- Thread starter razorexcel
- Start date
Excel Facts
How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
Welcome to the Board.
Have you tried Insert|Hyperlink then Browse for File?
Have you tried Insert|Hyperlink then Browse for File?
Upvote
0
razorexcel
New Member
- Joined
- Mar 4, 2009
- Messages
- 3
would I be able to email that to someone and they could pull up the PDF?
Upvote
0
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
Only if they had access to the file's path. Another option is Insert|Object, checking Display as icon.
Upvote
0
Mr. Walnuts
Board Regular
- Joined
- Aug 8, 2005
- Messages
- 176
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.
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.
Last edited:
Upvote
0
Similar threads
- Solved
