combo box printing

  • Thread starter Thread starter hannibal
  • Start date Start date
H

hannibal

I have created a few combo boxes on an excel spreadsheet, that work ou
great... But now I am trying to figure out if there is a way to hid
the actual button for the combo boxes so that it doesn't show up whe
printing the sheet.. I want the infor
mation that is contained in the combo boxes to appear when printed bu
I don't want that arrow button to show up... Any help or ideas would b
greatly appreciated..
 
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
 
Back
Top