Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Basic Forms in Excel - enable checkbox? 1

Status
Not open for further replies.

jazminecat

Programmer
Joined
Jun 2, 2003
Messages
289
Location
US
Hi, I'm not used to making forms in Excel, so I'm kind of lost. I'd prefer this to be in Word, since it's just a form the users email back and forth after completion, but the powers that be want it to remain in excel.

I have a form, it's a checklist used by different departments, and they print it when it's finished to attached it as documentation to lab reports and workorders. It's just a form, with text fields, and a series of checkboxes. I figured out to unlock the cells I want them to type their information into, and then protect the sheet allowing users to select unlocked cells, and they can tab through to enter their information.

But...I can't seem to figure out how to make the checkboxes 'check' when the form is saved. If I unlock them, they just get selected like for editing when the user clicks them. If set the locked property to true, they don't 'check' when the user click them. Thanks in advance for the help with what probably is a rudimentary problem.

 
You need to unlock and then turn off design mode (I assume you have used Controls Toolbar checkboxes) - this is the little blue set square that should look indented at the mo

Rgds, Geoff

A file that big? It might be very useful. But now it is gone

Please read FAQ222-2244 before you ask a question
 
I knew it would be something simple. Thanks Geoff for the superfast reply! Have a star - I can't be the only person who needed to know this.
 
nor the 1st to be tripped up by it !!! Guess how I knew ;-)

Rgds, Geoff

A file that big? It might be very useful. But now it is gone

Please read FAQ222-2244 before you ask a question
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top