Gaurav Karira
Board Regular
- Joined
- Jun 13, 2003
- Messages
- 121
Hio Guys
this should not tough for u experts out there...
I have a very huge file.......14MB..... has loads of formulassss Vlookups in tons........ and on top of it , this would be used by many people...
what help I m looking for ......
I need a Vba/ Macro which would do a detail calculation something like CTRL+ALT+F9....... thro all the worksheets.......
I mean I would give a button which when user presses the the calculation wd be done thro out the workbook......
Also if someone can add a status bar in macro in that macro with a message like "Please wait calculating data" that would just be gr8
I dont know If i m expecting toooo much but i guess this wont be much tough for u experts .....
I have my work books on manual calculation and want to keep them manual only as otherwise my excel wd crash....
Thx
this should not tough for u experts out there...
I have a very huge file.......14MB..... has loads of formulassss Vlookups in tons........ and on top of it , this would be used by many people...
what help I m looking for ......
I need a Vba/ Macro which would do a detail calculation something like CTRL+ALT+F9....... thro all the worksheets.......
I mean I would give a button which when user presses the the calculation wd be done thro out the workbook......
Also if someone can add a status bar in macro in that macro with a message like "Please wait calculating data" that would just be gr8
I dont know If i m expecting toooo much but i guess this wont be much tough for u experts .....
I have my work books on manual calculation and want to keep them manual only as otherwise my excel wd crash....
Thx
