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.