Basic Forms in Excel - enable checkbox? 1

[jazminecat]

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.

 

[xlbo]

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

 

[jazminecat]

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.

 

[xlbo]

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