Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
al al is offline
external usenet poster
 
Posts: 363
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
No printing of drop down box Al Excel Worksheet Functions 2 January 4th 08 08:12 PM
Excel Printing --Borders are not printing on the same page as data Stup88 Excel Discussion (Misc queries) 1 August 7th 07 09:34 AM
can I ensure a drop down list is used i.e by preventing printing Have a Go Excel Discussion (Misc queries) 1 December 15th 06 04:27 AM
Cross-referenced drop-down menu (nested drop-downs?) creativeops Excel Worksheet Functions 4 November 22nd 05 05:41 PM
Enable Double sided printing contiuously when printing multiple s. Lee Excel Discussion (Misc queries) 1 November 27th 04 01:58 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"