Excel Q&A

Re: Adding hyperlink to header in Excel

Hi Elliot,

Quick question to clarify your end goal: Will the hyperlink be "clickable" on a PDF version of the Excel file? Will it be a text hyperlink or an image?

0

by WST Expert 1.

added 7 years ago

Re: Adding hyperlink to header in Excel

It is actually a link to a website. So the header has an image in it (company logo), and I would like the logo to be clickable (in the PDF version of the excel file), and send you to the company's website.. Thanks

0

by Elliot S.

added 7 years ago

Re: Adding hyperlink to header in Excel

Header pictures in VBA are instances of a Graphic object, which unfortunately cannot have any hyperlinks (reference: https://msdn.microsoft.com/en-us/vba/excel-vba/articles/pagesetup-leftheaderpicture-property-excel). However, you could write a macro to insert a specific image from your computer ... Read More

0

by WST Expert 1.

added 7 years ago

Re: Adding hyperlink to header in Excel

Yea I guess I will have to go with the alternative approach. But does the alternative approach need a macro or can I just add a hyperlink to an image in excel?

0

by Elliot S.

added 7 years ago

Re: Adding hyperlink to header in Excel

If you're simply inserting an image manually, you can easily make it a link via Ctrl + K (or right click, Link -> Insert Link...). Afterward, you can copy this image link and paste it throughout your Excel file. VBA would likely be useful if you had a lot of pages (or a dynamic number of pages_, ... Read More

0

by WST Expert 1.

added 7 years ago

Re: Adding hyperlink to header in Excel

Ok sounds good. Really appreciate the help, thanks!

0

by Elliot S.

added 7 years ago

Questions/Discussions

Sort by Date ▼ / Top Rated