How can I get the compo box results to print - but not print the combo box
outline and down arrow? If I de-select "print" in the format control I
don't get anything printed.
I know I can put the combo box cell link, but I would like to leave the cell
link out and just not print the outline of the combo box.
Thanks
Hank

If these are combo boxes from the Control toolbox, you can do the following:

Switch to Design Mode (click the Design Mode button on
the Control toolbox)
Select the combo box, and click the Properties button
on the Control toolbox
Set ShowDropButtonWhen to 1-fmShowDropButtonWhenFocus
To hide the combobox borders, set SpecialEffect to 0-fmSpecialEffectFlat

Or, change the settings in the Workbook_BeforePrint event:

With Sheets("Sheet1").ComboBox1
.ShowDropButtonWhen = 0
.SpecialEffect = 0
End With


Hank Hendrix wrote:
How can I get the compo box results to print - but not print the combo box
outline and down arrow? If I de-select "print" in the format control I
don't get anything printed.
I know I can put the combo box cell link, but I would like to leave the cell
link out and just not print the outline of the combo box.
Thanks
Hank




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html