View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Paul D[_2_] Paul D[_2_] is offline
external usenet poster
 
Posts: 38
Default remove drop down arrows

We typically create the combo box so it is the same size as a cell and place
it over the cell where we want it to print. Then set the combo box to not
print and link the cell value below to the combo box. This way when you
print, you only see the value in the cell and you can format the cell anyway
you like.
Paul D

"Hank Hendrix" wrote in message
...
How can I remove the drop down arrow and border from a combo box. I would
like it to appear when the mouse is over it. I do not want the border or
arrow to print.