Macro for saving different sheets as a PDF

It really helps to include a copy of your workbook.

For starters, you reference a specific worksheet in your code (ProductRatingTool). To start with, you can begin with this link that shows how to export each worksheet to a PDF.

You will need to add the following to ActiveSheet.PageSetup:

Please Login or Register  to view this content.

You will then need two IF statements. The first IF statement will need to see which checkboxes are checked. Without seeing your workbook, it's difficult to know which checkbox you're using. The other IF statement would modify your ProductRatingTool worksheet to how you have it configured in your code above.

I have added the attachment now.
However, that's just sample one.

How do I achieve the same here?

??? Your workbook doesn't have the checkboxes you mentioned. Are you asking me to write the VBA for you instead? I'd prefer if you try yourself, and I'll help you as you need. This way you learn how yourself. Kind of like teaching a man to fish and and you feed him for a lifetime!

Please check the excel attached with the User form and all the codes.

I've updated the excel now and attached the correct one. Please check.

Now it makes more sense. Let me look at it a little while. I do have a question for you - when does the user press 'Button 2'? I'm curious because it could possibly be automated with an even trigger (such as on close).

Maybe you can change this to your needs. If not, just delete it.