excel sheet with vba coding

[sunita_sug]

i have a worksheet with vba coding which takes abnormally
long time to open.
I deframented the drive but still did not make any
difference in the time it takes to open.
What could be the reason and what should be done to
overcome this.

 

[Ron de Bruin]

Hi

Check out also this site's

You can use Rob Bovey's Code cleaner to clean up your code
http://www.appspro.com/utilities/utilities.asp


Opening/Saving Bottlenecks (Charles Williams)
http://www.decisionmodels.com/optspeedd.htm#OpSave

Troubleshoot Startup Problems(MS):
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q280504

Some tips on overcoming slow response (David McRitchie)
http://www.mvps.org/dmcritchie/excel/slowresp.htm