Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide or remove filter arrows from protected pivot table | Excel Discussion (Misc queries) | |||
How do I remove the arrows after showing dependencies | Excel Discussion (Misc queries) | |||
Displaying drop down list arrows | Excel Worksheet Functions | |||
DROP DOWN ARROWS | Excel Discussion (Misc queries) | |||
Getting rid of drop down arrows | New Users to Excel |