MacroNoob17
New Member
- Joined
- Jul 27, 2017
- Messages
- 1
Hello, I'm new to the message board but I have been unable to find an answer to my problem.
I have a project workbook (used by several people) that produces reports for multiple companies. Each report needs to have the company logo in the footer section when printed. Currently I have the logo images (jpg) on my hard drive with a macro pointing to them that swaps the logo in the footer area on a button click. This is fine for testing but I would like to store the images in the workbook. When I use the normal insert footer image its looking for a drive path, is there a way to have the path point to an image stored on a sheet in the workbook (instead of c:\users\... it would look like xxx.xlsm\sheet1\cellA1)?
Thanks in advance
I have a project workbook (used by several people) that produces reports for multiple companies. Each report needs to have the company logo in the footer section when printed. Currently I have the logo images (jpg) on my hard drive with a macro pointing to them that swaps the logo in the footer area on a button click. This is fine for testing but I would like to store the images in the workbook. When I use the normal insert footer image its looking for a drive path, is there a way to have the path point to an image stored on a sheet in the workbook (instead of c:\users\... it would look like xxx.xlsm\sheet1\cellA1)?
Thanks in advance
