Hiding Check Boxes In VB excel 2007

[starrysky]

Hello!!

Im Having trouble with my Visual basic code in Excel 2007.
I'm using the code to hide two rows which works fine, however my code to hide the check box (second line of code) doesn't work so if anyone can see where I'm going wrong that would be great

Sub CheckBox17_Click()

Rows("34:35").Hidden = Not (Rows("34:35").Hidden)
ActiveSheet.CheckBoxes("CheckBox19").Visible = Not (ActiveSheet.CheckBoxes("CheckBox19").Hidden)


End Sub

 

[bk]

Doesn't just

'''''.Visible = False

do it?

 

[starrysky]

Nope tried that but it says its a compiled error

 

[bk]

I'm self-taught; so, take that disclaimer.

But I would've just used the code:

CheckBox19.Visible = False

unless there was a reason I couldn't.

How about that simpler line of code? It worked for me in a quick test

 

[starrysky]

Thankies! Simpler code is fine as long as it does the job however i still cant get it working it just says debug although its probably just me missing something out.