Hi everyone - avid reader, first time poster here, so please forgive me if I don't get things exactly right first time.
I have created a macro (with the limited exposure that I have had to vba) to create a pdf of certain sheets and compose an email with them based largely upon the ron debruin macro. This has never caused an issues for me up until now. I should say that I have been running the macro in a file created in Excel 2007 and am experiencing the issue in Excel 2010. The problem now is that, although the pdf created is fine,the excel workbook itself has an image on one of the pages shift over populated cells to make them unreadable. I have formatted the image to try both "Do not move and size with cells" and also "Move and size with cells" and have the ensured that it is "Locked" but none of this seems to help. I thought I would ask the question first without posting the code, in case this is a common problem with an easy fix. I will happily post the code if you think it is necessary. Thanks in advance for your assistance.