ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   remove drop down arrows (https://www.excelbanter.com/excel-programming/307389-remove-drop-down-arrows.html)

Hank Hendrix[_2_]

remove drop down arrows
 
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.



GJones

remove drop down arrows
 
Hi Hank Hendrix;

I do not believe you can make the drop down arrow go away
but you can go into the properties for the drop down and
set it not to print.

Depending on which drop down you used,(there are two
different kinds) to get to the properties you can (1)
double click on the drop down or (2) click once on it and
then press F4.

Thanks,

Greg



-----Original 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.


.


Paul D[_2_]

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.






All times are GMT +1. The time now is 04:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com