Check Box / Hide Objects

[batchy]

Hi,

I have a check box which i would like to hide a range of Objects when unselected. It will then show the items when it is selected.

The code i currently have set up is:

Please Login or Register  to view this content.

The above works but i want it to go all the way to "Grp81". If i put all the group in it fails :s

Any suggestions appreciated

[cytop]

This seems to be a continuation of your earlier post... http://www.excelforum.com/excel-prog...ml#post3466075

If possible, add all your shapes to one group... then

Please Login or Register  to view this content.

[batchy]

Unfortunately i cant group all the objects as one.

As some columns are hidden, when i hide certain columns and the objects are grouped it moves the objects from cells :s

[cytop]

Then you need some way to identify which shapes to show/hide, setting that attribute as you loop through all the shapes on the worksheet...

For example

Please Login or Register  to view this content.

Obviously this means the shapes have to have a consistent naming convention. If this still does not suit, then please upload a sample copy of your workbook.

[mikerickson]

Try

Please Login or Register  to view this content.

[batchy]

Thanks for the speedy reply.

I have 24 objects in each group and 81 groups in total.

Is there not a way i can do this via group with a consistent naming convention? This is why i have named the groups grp1, grp2, grp3 etc...

[batchy]

Hi Mike,

Can you clarify where i should put this in the code above?

Kind Regards

[batchy]

Excellent solved the issue many thanks