Hi there, I need your help again.
I'm creating a Time attendance Report Sheet.
So far with your help the Sheet for January and it's working as I need it,
The sheet contain the coming and going time, then night shift, and every thing I need, I've also created for each day 7 ActiveX Toggle buttons
1 for Holiday, 2nd for Vacation, 3 Sickness, 4 Regular Day off, 5 Unpaid, 6 Company Business and the last one for Compensate. each Button is a Triple Toggle Button
True return 1 for a full day, False returns 0.5 for a half day and 0 gives 0. of course each button has his own cell for the Variable (0, 0.5 or 1).

I have also one module in VBA which activate all Buttons once the Workbook opens.
again so far everything works like a charm.
Now I've start to make a copy of Jan sheet and renamed it Feb which duplicate the buttons without changing their names which is what I need as I want to use one VBA module for each Category of button they are names S1 to S31 , V1 to V31 etc...

again everything worked until I came to the month of August. when I did a copy of the august Sheet and renamed to September. the Workbook suddenly freezes and I hear the Sound when a warning message appear, but I couldn't see any warning Message, and when i tried to hit any key or even moved the mouse I keep hearing the same sound again and again.
after a few minutes the entire sheet disappeared.

Fortunately I have a backup until the month of June, I disabled the VBA macro.. but again once I reach to the month of Sep same thing the WB freezes and crashes.
I thought it's maybe because so many buttons have the same name, so I created new one starting from the month of July with different name.. but again same thing

So I'm sure it's due I have so many buttons about 1267 buttons, I think there is an limit in the number of objects in one Sheet (I have Excel 2010)

the thing I don't know what alternative I have I want that the user click on a button instead of writing down 0, 0.5 or 1 n those cells...

the size was also 6MB as XLSM file so I saved it aS XLSB and it reduced to 3MB....