VBA running slow in Excel

[Dukster131]

I am creating a VBA project in Excel for a company. It was working and loading fine and then suddenly whenever I tried to load the file or exit the file it was extremely slow (several minutes).

Is there a reason for this to happen.

The file is about 2.5 mb.

I have tried removing the modules and forms and saving the file and the importing the modules and forms, but this didn't seem to help

 

[Chance1234]

Try adding into your code

Application.screenupdate = false

Also normally slow code in Excel can also be attributed to the worksheets themselves, ie have you got shading or coloured fonts in cells that arenet needed, are there any [citures that could be got rid of or shrunk in size, do you have any external linking in the spreadsheet, etc etc

http://WWW.5YLAC.S5.COM