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
 
Top