I am relatively new to using embedded objects & using VB code to have the objects function as I need them to. Currently I am using Check Boxes & Combo Boxes in a few workbooks at work. The workbooks worked out well & have realy simplified the job. However, after several weeks of using the workbooks they are now taking a long time to open, & even a longer time to print. I have simplified the code & deleted as many of the check boxes as I could. From this point I'm stumped.
I have checked the memory to make sure that the workbooks are not maxing out the memory. I have noticed that the cpu usage is jumping to 100% when opening & printing the workbooks. Any ideas.
I have checked the memory to make sure that the workbooks are not maxing out the memory. I have noticed that the cpu usage is jumping to 100% when opening & printing the workbooks. Any ideas.