Dynamically enabled checkboxes

[vijayendra.shukla]

Hi,

I am having an report in which first sheet "Template" and last sheet "Final Sheet" are always there but inbetween sheets are changing. Other sheets contain data based upon the months and follow the naming conventin "MMM2010". In the final sheet there are cells which fetch summation of data from all those month's sheets respectively. to get the customized data in the Final Sheet i created the user form which contains checkboxes with every month of the year bcoz i could not think of any way to dynamically create checkboxes in the user form. I mean i could not think of a code which can just check whether the sheet for the January month is there or not and based upon it creates the checkbox for that month.

so i though of creating all 12 checkboxes and trying to enable only those checkboxes for which worksheet is available in the workbook.
can anyone please help me how do i do it?

 

[savindrasingh]

You can enable/disable the check-boxes based on the sheets count while loading the workbook i.e. on workbook_Open event.