Hi,
I have 9 sheets in a workbook.
Every sheet has different data inter linked with one another.
I have specified a specific print area for each sheet.

I want to allocate a click button for each sheet where the print area selected gets saved in a desired folder in PDF.

And also another button if I want to print it if possible.

I have tried many codes however they do not work.
i am sure there must be a simple way of doing it.
Earlier codes, the entire workbook gets saved which I don't want.
I want a specific sheet to get this function.
Can anyone help please

Thanks