Hiding All Checkboxes when I open/close the workbook

[nouveauricheinvestments]

Hi,

I have a very advanced drill down model with checkboxes on several
rows. I have buttons that hide rows and as well as the checkboxes
when I want to 'drill up'. This works fine and keeps the checkboxes
in their correct row. However, when I close the workbook, all of my
checkbox hidden properties are set to false. The result is when i
open the workbook again, all of the checkboxes are not referenced in
their correct rows. How do I Make sure that all checkboxes remain
hidden when I close the workbook as well as open it?

Is there a way to reference ALL checkboxes in the sheet and set their
property to hidden, rather than just one or two?

Thanks for your thoughts.

 

[JMay]

How are your checkboxes created? Forms or Active-X

 

[nouveauricheinvestments]

How are your checkboxes created?  Forms or Active-X

They are all active x controls...

 

[nouveauricheinvestments]

They are all active x controls...

Any ideas? I was thinking to make life simple, or maybe cause it's
the only way I can think of to do it - I can have a select case
statement in the workbook close event that calls a boolean function
that checks to see if all checkboxes/buttons are visible and rows are
unhidden. If so, it will allow the workbook to close. If not, it
will give the user a messagebox telling the user to select a button
that will display all buttons/checkboxes/rows.

Any better ways to do it than that?