Hiding All Checkboxes when I open/close the workbook
 

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.

Hiding All Checkboxes when I open/close the workbook
 

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.

Hiding All Checkboxes when I open/close the workbook
 

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...