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.

How are your checkboxes created? Forms or Active-X

" wrote:

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.

On Nov 15, 3:10*pm, JMay wrote:
How are your checkboxes created? *Forms or Active-X



" wrote:
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.

They are all active x controls...