Creating PDF from assigned sheets

[pasj]

Hi guys,

I said yes to a project not knowing quite what I got myself into, so I'm here hoping for a helping hand. I understand basic VBA maneuvers, but I'm no wizard, none what so ever.

I am working for a company who would like to send out offers to clients who they visit. They sell 3 kind of products and not all customers will need a quote for all 3 services.

On the front page i will therefore need a marking tool for each of the services which Excel can read and create the PDF from that marking. And easy click-box will be sufficient. That i can easily handle myself.

If they mark the services the CreatePDF VBA programming will need to only create the sheets which is marked at the front page. Do you understand?

Each of the services will need a sheet for itself

I have used a variant of this brilliant VBA macro:

Please Login or Register  to view this content.

This only selects and prints the active sheets. I will need to select the sheets marked at the front page. I'm pretty lost and dont know where to go from here.

[Leith Ross]

Hello pasj,

Without seeing your front page, knowing the layout, the controls used or any code behind them, makes it pretty much impossible to answer your question. Unless, you're psychic which I am not.

I would suggest you post a copy of your workbook. this will answer the previous questions and allow any solutions to be tested directly.

If your workbook contains any sensitive information, please redact that information before you post.

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

[pasj]

Thanks for the tip Leith,

I might have overestimated my own skills in getting the topic understandable, so a upload of the excel might be in place.

Here is the upload Test-upload.xlsm

I have 7 sheets. The front page and a price calculator and the quote page for each of the 3 services we provide. Price calculators are in sheet 2-4 and quotes in 5-7. When the button for a service is marked it should create a pdf for the right sheets in sheet 5-7.

Hopefully you understand me now.

Thanks in advance