simon clark
New Member
- Joined
- Oct 14, 2002
- Messages
- 29
My spreadsheet has over 30,000 formula (due to a large 37 x 37 grid) and it takes about 2 minutes to recalculate. This is annoying when the system freezes whilst recalculating so it is easier to turn it off until i have finished entering data.I know it is possible to turn "recalculate" on and off by macro, but:-
1.Is it possible to display the recalc status in a cell so i know whether or not it is turned on or off.
Additionally (not really to do with this problem - just a general question):-
2. I have only ever used VBA by macro i.e. click a button to run the macro. Is it possible to make the VB code run in the background constantly without having to trigger the event by macro e.g. when anything changes or is updated.
Thanks in anticipation
Simon Clark
1.Is it possible to display the recalc status in a cell so i know whether or not it is turned on or off.
Additionally (not really to do with this problem - just a general question):-
2. I have only ever used VBA by macro i.e. click a button to run the macro. Is it possible to make the VB code run in the background constantly without having to trigger the event by macro e.g. when anything changes or is updated.
Thanks in anticipation
Simon Clark