Exporting Checkboxes to PDF

[tmleynek]

Hi all,

I currently have a macro button that prints a review sheet and billing sheet to PDF with a bunch of form control check boxes. The review sheet is about 3 PDF pages long. The first page doesn't display any of the objects, while the second and third pages have all the check boxes displaying. Is this something with the coding (below) or just a general bug with excel?

When I print to PDF normally (file-->print) all checkboxes are displayed correctly. I would like this macro for simplicity of just a click and it creates a standardized naming convention.

Please Login or Register  to view this content.

[LJMetzger]

Hi tmleynek,

If you want all the CheckBoxes displayed in the pdf file, make sure the 'Print Object' attribute is checked in the 'Format Control' Properties Tab.

Lewis

[tmleynek]

Thanks for the reply. I've made sure each checkbox has "Print Object" checked. It's weird because its literally just the first page of checkboxes that aren't showing. The other two pages show the checkboxes with/without checkmarks just fine.

[LJMetzger]

My pdf files are only one page long. My 'Active X' CheckBoxes display fine with or without the CheckMark both when printing and in a pdf output file in Excel 2010 on Windows 8.1.

If you need additional help, please upload a sample file that demonstrates the problem.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[tmleynek]

This has been solved. The issue was with one of the logo images I pasted into the workbook was screwing it all up.

Thanks for the help!

[LJMetzger]

Your very welcome. I'm glad you found a solution.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Lewis