How do I print a template with only selected checkboxes

S

SharksFan

I am creating a template with checkboxes for selected criteria. Once all of
the criteria (checkboxes) are selected, I want to print the document and only
include the items that have been selected. Can this be done?
 
D

Dawn Crosier, MVP

You do have the option to print the data only. Tools, Options, Print, Data
Only. I'm not sure that is what you want, but if it is not, then I might
try changing the font of the unselected items to White text on a white
background. Since you are working in VBA, you could do that on the OnExit
event of one of your formfields.

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"

This message was posted to a newsgroup, Please post replies and questions
to the group so that others can learn as well.
 
J

Jezebel

Identify each of your items by bookmark; then for each item you don't want,
set [Bookmark].Range.Font.Hidden = true
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top