Printing each sheet to pdf with a unique pdf password

[katrlow]

Hi

Does anyone know how to create a macro to print each excel sheet to pdf & password protecting the pdf document to a unique password (that's in the sheet) and repeating the process for the whole spreadsheet?

Thanks!
katrina

[excelliot]

Does any body now solution for this...