I have a workbook with many sheets that each must be individually saved/printed as a pdf every month. I would like the name of the pdf file created to be the sheet name from the workbook (not the workbook name). Each month a few new sheets could be added to the workbook. When I save as / print a pdf, it defaults to the workbook name.
I'm not overly familiar with macros, but I could record one printing each sheet as a pdf, however:
- Not sure how to automate the naming of the pdf file (want it to be the sheet name)
- If I record a macro of printing each individual sheet, it will not pick up the new ones (so would need to modify macro each month for new sheets).
Any help is appreciated!
Thanks
Gord
Bookmarks