print hidden sheets to pdf

[mmikem]

I need some help in modifying some code here I need to export hidden work sheets to PDF files I have the
following code that works for printing if it can be changed to print the sheets as seperate pdf's and save to a folder on my c:docs/file name

Please Login or Register  to view this content.

Any Ideas thanks

[TMS]

Untested, but try this … Record a macro to save a sheet, any sheet, as a .pdf. Then edit that to change the file name to prnArr(i). Finally, replace .PrintOut with your recorded and edited code.