Printing Question?

Todd_M · Mar 25th, 2002, 07:21 PM

Hi-
When printing a part of a sheet that contains comboboxes (dropdown boxes), Is it possible not to show those dropdown boxes (little boxes with the arrows)on the printed sheet?

Tom Schreiner · Mar 25th, 2002, 07:36 PM

Hi
While in design mode, right click the object(s) in question, from the popup menu choose format control, Click on properties, clear the print object check box?
Ok
Tom

Todd_M · Mar 25th, 2002, 07:47 PM

Todd_M · Mar 25th, 2002, 07:48 PM

Thanks Tom!

Yogi Anand · Mar 25th, 2002, 07:53 PM

Hi TsTom and Todd_M:
If there are too many controls to individually select and disable printiting of the object, how about TOOLS|OPTIONS|VIEW|Objects ... Hide all
Of course one drawback with this is that the controls will not be viewed either -- but then after printing one could turn the setting back to Show all.
It may not be relevant here, but I thought I will mention it anyway!

Mar 25th, 2002, 07:53 PM	#5
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Hi TsTom and Todd_M: If there are too many controls to individually select and disable printiting of the object, how about TOOLS\|OPTIONS\|VIEW\|Objects ... Hide all Of course one drawback with this is that the controls will not be viewed either -- but then after printing one could turn the setting back to Show all. It may not be relevant here, but I thought I will mention it anyway! __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 07:21 PM	#1
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	Hi- When printing a part of a sheet that contains comboboxes (dropdown boxes), Is it possible not to show those dropdown boxes (little boxes with the arrows)on the printed sheet?

Mar 25th, 2002, 07:36 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi While in design mode, right click the object(s) in question, from the popup menu choose format control, Click on properties, clear the print object check box? Ok Tom

Mar 25th, 2002, 07:47 PM	#3
Todd_M Board Regular Join Date: Feb 2002 Posts: 117

Mar 25th, 2002, 07:48 PM	#4
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	Thanks Tom!