No printing of drop down box?
Right click on the dropdown or combobox.
Choose Format Control On the Properties tab, uncheck the "Print object" box. Al wrote: Is there a way to use a drop down box in a cell but not have it priint the box just the value selected? -- Dave Peterson |
No printing of drop down box?
ps. Depending on what type of dropdown/combobox you used, you could use a
linked cell that's directly under the combobox to see what was chosen. Dave Peterson wrote: Right click on the dropdown or combobox. Choose Format Control On the Properties tab, uncheck the "Print object" box. Al wrote: Is there a way to use a drop down box in a cell but not have it priint the box just the value selected? -- Dave Peterson -- Dave Peterson |
No printing of drop down box?
Wow!
That was easy! Thanks! "Dave Peterson" wrote: ps. Depending on what type of dropdown/combobox you used, you could use a linked cell that's directly under the combobox to see what was chosen. Dave Peterson wrote: Right click on the dropdown or combobox. Choose Format Control On the Properties tab, uncheck the "Print object" box. Al wrote: Is there a way to use a drop down box in a cell but not have it priint the box just the value selected? -- Dave Peterson -- Dave Peterson |
All times are GMT +1. The time now is 09:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com