I have 2 worksheets on a macros enabled workbook.
WorksheetA and WorksheetB
In Cell A1 of WorksheetA, a user can put whatever text they want in there ...I also have a command button on WorksheetA.
How can I make it so that when the user clicks the command button on WorksheetA, it saves WorksheetB as a PDF on the users desktop and names it whatever the contents of 'WorksheetA'!A1 .pdf?
Bookmarks