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)?

 

[jkpieterse]

What happens if you close Excel and clean out your temporary files (open Explorer, type %temp% in the address bar followed by enter and try to delete everything there)

 

[Eddy2]

What happens if you close Excel and clean out your temporary files (open Explorer, type %temp% in the address bar followed by enter and try to delete everything there)

Thanks for your reply. Same load time after deleting the files in the tmp folder.

 

[jkpieterse]

In that case I guess there isn't much you can do.
One thought: Are you sure there are "only" 150 of them? I've seen quite some cases with many controls covering each other.

 

[Eddy2]

In that case I guess there isn't much you can do.
One thought: Are you sure there are "only" 150 of them? I've seen quite some cases with many controls covering each other.

I have 222 OLEObjects in my workbook to be precise

 

[Eddy2]

Seems like changing to Form controls is the only solution. It would be interesting to know why Active X control affect the startup time while Form controls doesn't .

 

[jkpieterse]

I'm not convinced form controls will do much better, but it is worth a try. With 222 controls it seems there are 72 duplicates?

 

[Eddy2]

I'm not convinced form controls will do much better, but it is worth a try. With 222 controls it seems there are 72 duplicates?

No duplicates - i only counted the check boxes in my first message, i also have other active x controls in my workbook.

I have replaced the Active x check boxes with form control check boxes, and the load time of the workbook was considerable reduced.

Quick google search which may explain the load time : "Form controls are built in to Excel whereas ActiveX controls are [FONT=arial, sans-serif]loaded separately"[/FONT]

Thank you for your feedback

 

[My Aswer Is This]

Would you care to tell us what you use all these controls for.
222 controls with scripts assigned to all these controls seems like a big task.
Maybe we could provide another way to do things.

 

[Eddy2]

Would you care to tell us what you use all these controls for.
222 controls with scripts assigned to all these controls seems like a big task.
Maybe we could provide another way to do things.

It for a price sheet:
· Calculate offers to customers
· Create service invoice
I have assigned scipts to two “master” check boxes. 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.
In addition I have created buttons to quickly modify the prices (former active x, now form controls)