Hiding Checkbox from "Forms" Toolbar

I have some rows that I want to hide in my spreadsheet, I also have
checboxes within those rows to hide. When I hide the rows, the
checkboxes remain. I know if i use the checkboxes from the control
menu I could change the properties to allow it to be hidden with the
cell, however size of the program is an issue and the forms objects are
smaller. Is there code like checkbox1.visible = false i can run with
me hide rows macro, or some other formatting property i am missing.
TIA


---
Message posted from http://www.ExcelForum.com/

The problem is that the checkbox is a shape...

Sheets("Sheet1").Shapes("Check Box 1").Visible = False

K


---
Message posted from http://www.ExcelForum.com/

You are awesome kkknie, thanks, it works .


---
Message posted from http://www.ExcelForum.com/

Another question, how would you put this line of code in a for loop,
ex:

For i = 1 To 10
Sheets("Sheet1").Shapes_(\"Check_Box\"_&_i)_.Visib le = True
next i

I know this will not work, so how can i write the code to make it work.


---
Message posted from http://www.ExcelForum.com/

One way:

dim i as long
for i = 1 to 10
Sheets("Sheet1").Shapes("Check Box " & i).Visible = False
next i

I'm not sure what the backslashes and underscores do, though.

"bg18461 " wrote:

Another question, how would you put this line of code in a for loop,
ex:

For i = 1 To 10
Sheets("Sheet1").Shapes_(\"Check_Box\"_&_i)_.Visib le = True
next i

I know this will not work, so how can i write the code to make it work.

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson

any hints on my above question...


---
Message posted from http://www.ExcelForum.com/

Just the one from yesterday.

http://groups.google.com/groups?thre...533E%40msn.com

"bg18461 " wrote:

any hints on my above question...

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson