Combo Boxes on Spreadsheet

  • Thread starter Thread starter Shari
  • Start date Start date
S

Shari

I have a created a template in Excel which has several combo boxes. Is
there a way when printing these sheeet the combo box doesnt appear but
the information within the box does?
Thanks- Shari In Pa.
 
try setting the LinkedCell property on the combo box to
the cell directly underneath it. then set the
PrintObject property to false. that will put the data in
the cell below so it prints when the print job ignores
the object.
this assumes you used the Control Toolbox to create the
combo box. if you used the Forms menu, ctrl + right
click on the combo box and choose Format Control. the
Cell Link property is on the Control tab and the Print
Object check box is on the Properties tab.
hope that helps.

mike
 
Miklee101 :) :D Thanks so much for replying. I am going to try this.
I will let you know if it works
 
Back
Top