Excel 2007 : Checkbox in cell -not Form Control

Right click on the Check Box and then select "Form Control..."
Click on the Properties tab of the Form Control dialog box.

Try the other option combinations to see if one fits your needs.

Thanks but this did not work. Still stays visible when I hide the row

I"ve played with checkboxes in cells and have failed in the past. I now just put an X or blank in the cell. I've found it is a lot less overhead and a lot easier to work with.

Yes I know that is what we are doing now, however it will be less time consuming for those who use the spreadsheet to be able to just click on the box rather than click, then type. In a world going electronic we re trying to make it as easy as possible.

Yes - as long as it is easy. I have a macro in to hide rows I do not need but it was a very simple one that I was able to record just hiding those rows. I use excel everyday, but I am not a programmer so I need 'beginner' language.

I'm with you on the whole concept. I created a double click in column 1 (Column A) that would put an X in or remove it.

Put this code behind the sheet (not the module) and change the column to the one you want to X.

Please Login or Register  to view this content.

The above code (behind the sheet, not module) will only work if you double click in Column 1. Change the <>1 to the column you want. When you double click in that column an "x" will be input. If an "x" is there it will go to a nothing.

This is how I resolved my problem that I think is similar to yours.

Thank You Marvin - what if I have multiple columns? There are different checkboxes in columns A-AA or 1-27? how can I change it for that?

I just had this brilliant idea but need to test it. The idea is like this...

Ctrl-Click on everywhere you might want an X on your worksheet. While they are all selected, name the selected cells with a named range.

Change the code above so it will only make an X if the range in in the named range.

Now off to see if that really works.. (before I get too excited about it being brilliant)

Thank you so much. I'm going to try it now

Well it is working for some of the cells. I think I may need to take a break from it and come back, it's starting to drive me nuts. I checked my name range and all cells I want included are in there, but this formula is only working for the cells on the top part of my spreadsheet and the ones towards the bottom are not working...Thank you so much for figuring this out for me. I guess I needed more help than I originally thought. I guess I'll try to muttle through it.

Ok - figured it out-name range only applies to 40 cells, had to add additional ranges for more cells.
Thanks again.

Ok, trying to setup a call monitoring form for a call center and I tried using the example above but won't let me name more than one cell the same name, keeps giving me an error message. I have 25 monitoring topics to either click yes, no or N/O (not observed). I'm at a loss.

By the way, this is a great forum!