Create seperate pdf files for worksheets in a workbood?

Try this code. This is done assuming 3 sheets in ur workbook. These will b saved with sheet names.

Change the code in red color to the location where u want to save ur file.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This will prompt you for a folder of where you want to store the PDF files and should work for any number of sheets you have in your workbook.
_____________________
[1] If this reply was helpful, click the star to the left.
[2] If this reply answered your question, mark this thread as [SOLVED].

This works great. I would like for it to skip hidden worksheets.

To skip the hidden sheets, try this.

Please Login or Register  to view this content.

__________________
[1] If this reply was helpful, click the star to the left.
[2] If this reply answered your question, mark this thread as [SOLVED].