All,



I am working on an Excel 2003 scoring tool for sales and professional
services. The approximate size of this file is 6MB, but it is largely
due to a number of controls embedded into Excel, not actual data.
There are about 40 worksheets, each with about 10 questions per sheet
and associated option buttons, text boxes, control bars, etc.
Performance slows down considerably after just 2 MB.



As an alternative, I broke the worksheet into smaller files of 3
worksheets each, and then call up a separate worksheet when a command
button is pressed and then close the worksheet I was just in. When I
do this, I receive an "Application-Defined or Object-Defined
Error". My goal is to significantly improve performance. Would any
of you have a few minutes to help me out with this?



Thanks,



Jeff