Need radio button groups with no visible properties of the group

[simusphere]

I have 16 groups of two radio buttons that run horizontally across the top of the sheet in very small cells so space is a premium. It looks horrible right now because of the visible line and label that surrounds each of the 16 groups overlap. I would like to know if there is way to turn that property off using vba since I can see no other way to do it. If it can be done, I could just use a macro to turn the visibility property on and off. Please help as this is one of final pieces of my current project.

[simusphere]

OK, I figured it out. You cannot group the group and radio buttons together, they must be separate for this to work which was why I kept getting errors.

For the first radio button group:

Please Login or Register  to view this content.

For the second radio button group:

Please Login or Register  to view this content.

Etc...

[AlphaFrog]

This macro will Hide all the Group Boxes on the active worksheet

Please Login or Register  to view this content.

[simusphere]

Thank you alphafrog, that will come in handy. I'm just in the beginning stages of learning to code in vba and it is starting to make sense. So I would like the above macro to run every time the workbook is open. How is that done?

[AlphaFrog]

Thank you alphafrog, that will come in handy. I'm just in the beginning stages of learning to code in vba and it is starting to make sense. So I would like the above macro to run every time the workbook is open. How is that done?

You're welcome.

Once you set the .Visible property and Save the workbook. They should be hidden the next time you open the workbook.

Two methods to run a macro on open.
1.) Name the macro Sub Auto_Open()

2.) In the ThisWorkbook code module, create a WorkBook_Open event macro.

Please Login or Register  to view this content.