Excel Question

[Sinster]

I want to use check boxes. I have "Protected" the sheet. How do I go about add a check mark when I click on the Check box? If I unprotect the cells I can't add the check mark and when I do click on the check box I can adjust the size of it. I don't want that.

 

[dadecamp]

You need to unlock the cells that you want to put the checkmark in. Select the cells (hold the ctrl key if more than one). Do Format, Cells.., Protection, un-check Locked. Of coarse the sheet needs to be un-protected while doing this.
After re-protecting the sheet the cells can then be used and you can move from one of the cells to the next by using Tab..

 

[Sinster]

I tried that but I still can't put Checks in the "Check Box". If I double click the "Check Box" a VB Window appears.

 

[Khayman]

Which version of excel are you using. i have 2003, and when i add a check box it ticks just fine with the sheet protected or not

 

[Sinster]

I am running 2003. When I try to use it as a check box, all it does is put the adjustment marks around it.

 

[Sinster]

I got it... I didn't have macro's enabled.