Excel app. lags on opening or closing...possible solutions?

[Excel-erate2004]

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

 

[Celtic_Avenger]

Turning off the screen refresh at open can sometime speed it up a little
I think.......It allows macros to run in background without the need to
refresh the screen after every code.

You need to make sure you turn it back on once opened.

This works well during long codes connected to VB Controls.

Application.ScreenUpdating = False

Application.ScreenUpdating = True

It may help.......but others may have a better idea!

Celtic_Avenger

 

[Excel-erate2004]

Thanks, I might give that a try