Disappearing Checkboxes

[Kappy]

I have a worksheet with some checkboxes in it (form control) and whenever I "save as" the file... they disappear (literally gone from the worksheet!)

Any ideas why this might be happening?

 

[AlphaFrog]

What file format are you saving as?

Do you hide any rows or columns, or filter data?

 

[Kappy]

I'm saving as XLSM (in Excel 2010 if that matters)

I do have a lot of hidden rows/columns. Very specifically, all of the checkboxes are in a hidden cell. It's built so that the user presses a button which unhides the cell with all the checkboxes.. then they can select what they want to see via those checkboxes, and then a macro hides certain rows/columns based on what is checked or not.

 

[AlphaFrog]

Depending on the properties of the checkboxes, they could move or resize when a row or column is hidden. Right-click on a chekbox and select Format Control. On the Properties tab, play with the Object Positioning properties to see if that has any affect.

Alternatively, your button that shows the hidden cell could also set the checkbox's properties e.g.;
Sheets("Sheet1").CheckBoxes("Check Box 1").Visible = True

 

[Kappy]

I have the properties set to "move and size with cell"... which I must do in order to have them hide when I hide the cells.

What's interesting, is that the .Visible = True code doesn't work, but it also doesn't error out (meaning that the checkboxes aren't totally gone somehow!)

Just to confirm your understanding, you think it's "normal" that I wouldn't be able to save a checkbox in a hidden cell?

 

[AlphaFrog]

Just to confirm your understanding, you think it's "normal" that I wouldn't be able to save a checkbox in a hidden cell?

Normal? No.

I think something is happening related to hiding the cell, but I don't know exactly what. So I'm throwing out suggestions as I don't have access your your workbook.

Perhaps the checkboxes are resized to 0 when hidden and then you save. Then they are not resized to their original pre-saved size when the cell is unhidden? If that''s the case, you could use VBA to set their size.

 

[Tanner_2004]

I wrote about this about a year ago. I believe MS Help forum indicated it was a known bug and one tey don't plan to resolve. It drove me nuts for days, until I found the blog. Check out the MS Community Help. I may be wrong.

 

[Ben_goldfinch]

I had the same issue what I had to do was unhide all rows on save when they are hidden they disappear but when they aren't hidden they don't

 

[Tanner_2004]

Thank you.