PDA

View Full Version : Solved: Macro's slowing down my spreadsheet



nepotist
03-28-2011, 11:42 AM
Hello,
I have written a few macros that look up a database and perform few calculations. I have about 12 sheets each representing a client. and all these 12 sheets use the macros that I have created.

Initally when I had only one client information in the workbook and was hoping from client sheet to data sheet the macros give me a error until I hit F9 (Calculate sheet). I updated my macros with "Application.Volatile = True" statement and called a sheet.calculate function when the sheet is activated.

But as I am adding all the client to this main workbook, there are freeze (though for a short while). I was wondering if there is a way I can avoid this.

Let me know if you guys need to look at the code.

Thank you