LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Kathy
 
Posts: n/a
Default Use of Control Tools

Two questions:

1) How do I add check boxes to items? I see the check box on the Control
Toolbar but how do I add them to cells? Does the worksheet need to be
protected first?

2) There is a drop down list of items already in a cell on the spreadsheet.
It is not visible until one clicks the cell. Then you see the arrow and the
list. I would like to get into the list to put a value at the top that says
"choose an option" AND have that option show so that people know to click the
cell. Again, do I need to protect the worksheet?

Thanks very much,
Kathy
 
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
Control Tab from Combo box- format control missing!! Mo Excel Discussion (Misc queries) 3 January 7th 05 01:09 PM
Copying list-box control Excel Discussion (Misc queries) 1 January 6th 05 01:39 AM
Why is pointer and keyboard control is lost in certain Excel file. MarkB3 Excel Discussion (Misc queries) 0 January 4th 05 07:15 PM
How do I link a macro to an ActiveX control? New Users to Excel 0 November 27th 04 11:04 AM
control keys peter Excel Worksheet Functions 0 November 24th 04 05:13 PM


All times are GMT +1. The time now is 08:22 AM.

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

About Us

"It's about Microsoft Excel"