ActiveX checkboxes slows down opening/load time of workbook

[Eddy2]

Hi
I have an Excel workbook with around 150 ActiveX checkboxes. All these Active X controls leads to long load time when opening the workbook (about 20 sec on my computer). Is there any way to speed up the load time of the workbook (without changing to form controls)?

 

[My Aswer Is This]

If you would like some other suggestions on how to do things let us know.
Show us the script your using in these:

For the rest I only use their state; I modify the price in the adjoining cells of the check boxes, only if their state is true.

 

[Eddy2]

Here is just an example:
https://www.dropbox.com/s/bwvs3kiok2yu1tu/Forum.xlsm?dl=0

Here is my new challenge:

Remove the equal sign in this code ("=1") and the code works as it supposed to. With the equal sign it inserts the formula in all offset cells, despite the state of the chk boxes = Xloff

 For i = 2 To 4
    
        If ActiveSheet.CheckBoxes(i).Value = xlOn Then
        ActiveSheet.CheckBoxes(i).TopLeftCell.Offset(1, 0).Formula = "=1"
        
        End If
    Next i
End Sub

If you would like some other suggestions on how to do things let us know.
Show us the script your using in these:

For the rest I only use their state; I modify the price in the adjoining cells of the check boxes, only if their state is true.