Hello,

I'm not sure there is a concrete answer for this question, but her
goes:

First up some background

I have an excel application that uses Excel 2000

- its size is 5.92 MB
- I have 8 sheets in this application
- approximately 50-70 checkboxes
- approximately 5-10 command buttons with VBA code behind the scene
for each button
- numerous cells with formulas that are dependant on preceding sheets

Whenever I open or close my Excel application it takes a while "to d
whatever its doing" before it will actually execute the actua
procedure of open or close. Or in other words it lags while shuttin
down or when I open it.

Why is this? Is there any way I can cut down on this loading time.

Does code that is not in use such as commented out VBA code add to thi
problem of lagginess (is that even a word)?

Thanks for any help I can get

Also worth noting:
I dont believe I have anything setup in the code that executes on th
worksheets opening

--
Message posted from http://www.ExcelForum.com