Problem with hiding a form control check box using code

[ABabeNChrist]

I’m having a problem with hiding a Form control check box using code
I have tried, with no success.

Code: Select all

Sheets("Structure and Exterior").Shapes("Check Box 29").Visible = False

Code: Select all

ActiveSheet.Shapes("Check Box 29").Visible = False

Now I am wondering if this could be my problem.
Within the same workbook I copied a worksheet named Grounds along with all of its controls, and named it Structure and Exterior. So now I have 2 identical sheets with only different names. So obviously all the form control check boxes have the same #.
I can use this code on the Grounds sheet and it will hide no problem

Code: Select all

Sheets("Grounds").Shapes("Check Box 29").Visible = False

Also here is my error message I receive

Error Message.JPG

[Jan Karel Pieterse]

Form controls are hidden members in the object list, you address them like so:

ActiveSheet.CheckBoxes("Check Box 1").Visible = True

[rory]

I suspect the names are wrong. What appears in the Name box if you right-click the control?

[sdckapr]

So obviously all the form control check boxes have the same #.

I don't think this is always true. Excel may choose to renumber them some starting at 1...
Steve

[ABabeNChrist]

Here is a view of the check box # on the Structure and Exterior sheet
This number is exactly the same at same location for the grounds sheet.
I’m puzzled because I’m referring to a specific sheet and shape

Check box.JPG

[ABabeNChrist]

I also tried Jan’s approach and I received this error message.

check box 2.JPG

I tried to duplicate the same approach I used on a new workbook and each and every code mentioned in this thread works great, even though the check boxes had the same #

[rory]

That's the macro dialog. It bears no direct relation to the name of the shape.

[ABabeNChrist]

That's the macro dialog. It bears no direct relation to the name of the shape.

When I right click and select veiw code, here is the top part of code refering to this check box
Sub CheckBox29_Click()
If not I'm not sure what you mean

[Jan Karel Pieterse]

Control+click on a check box. Then look in the name box to the left of the formula bar to see its name.

[rory]

Then the name is "CheckBox29" and not "Check Box 29" and you are using ActiveX controls, not Forms ones.

[ABabeNChrist]

Control+click on a check box. Then look in the name box to the left of the formula bar to see its name.

Walla, that was it
It didn’t even dawn on me to look in the formula bar; I had it closed off so I didn’t notice
I’m back in bussiness

Thank you Jan, rory and sdckapr