Formatting Combo Boxes-Hide the button

[rojj]

I have created a few combo-boxes in an excel spreadsheet.. Is there a
way to hide the "arrow-button" of the combo box when the sheet is
printed?... I have gone under Format Control > Properties > and
un-checked the print object box...However doing this not only hides the
combo box button, but also does not display the selected text of the
combo-box... I want text selection to show up, but I do not want the
button to show, when it is printed.....

The drop-down boxes (as they are called in Word) do exactly what I am
trying to accomplish, and I am trying to get the same result in
Excel......

So please help, any ideas or suggestions will be greatly
appreciated....

 

[Debra Dalgleish]

If this is a combo box from the Control Toolbox, set its LinkedCell
property to the cell under the combo box. Then, when you print, the
combo box will be hidden, and the cell that contains the combo box
selection will print.

 

[Dave Peterson]

It might be too late, but Data|validation is a pretty useful technique that
looks a lot like a combobox or a dropdown box.

See Debra Dalgleish's site for some nice instructions:
http://www.contextures.com/xlDataVal01.html

 

[rojj]

Thank you....I looked into the data validation technique, and tha
seemed to give me the desired effect I was looking for... So both o
you who replied, thank you for your suggestions and input..