I know this is a simple issue, but I want to make sure it is correct
I have a workbook with several macros for creating a PDF of reports. The issue I'm having is, if a page is copied to creat the same report for multiple vendors. The create pdf button makes a pdf of the original page not the copy.
I assume it this line causing the issue "Sheets("ToyotaMO").Activate"
Is there a way to change it so if I copy the page and press the create PDF button it generates that page not the original?
Thanks
Bookmarks