Hiding checkboxes in Excel

[DBAchick]

I have created a spreadsheet with a few checkboxes and radio buttons. I have grouped the cells that lie underneath the objects, but when I collapse the group (click the little "-" next to the row numbers), the radio buttons and check boxes remain on top and visible. Is there a way (either GUI or programmically) to surpress the objects when the row group is collasped?

Any suggestions are welcome.

Thanks!

 

[SkipVought]

Hi DBAchick,

Unless I am mistaken, there is bad new and good news.

The good news is that you can assign a Control's .Visible property. By assigning FALSE to the .Visible property, you can make that control invisible.

The bad new is that I can find no WORKSHEET EVENT associated with making Groups (Rows or Columns) hidden and unhidden. So there is no way to trap that event.

What are you wanting to do? There might be another way to skin the cat.

Let's say you collapse or expand a group of rows exposing row 10, for instance. If the user puts their cursor in Row 10, say, column 5, you can make a control appear. When the user uses the control, or when the user moves their cursor to another row, column, the control disappears. Would something like that work? Skip,
metzgsk@voughtaircraft.com

 

[DBAchick]

Thanks for you input Skip. After I started to 'click around' I found an option under format control that allows you to either move and/or size the control with the cell it floats above. I checked move and size with cell, and viola! they disappear when I collapse the group. Guess I should have hunted a little before I posted...

Thanks again,

DBAChick

 

[SkipVought]

OK,
You are using Forms controls as opposed to Tool Box controls. Glad you found a solution. Skip,
metzgsk@voughtaircraft.com