An easy solution is to setup the environment for the user and then restore it
prior to closing.

In a Workbook Open macro:
1. "remember" the original calculation mode
2. set the calculation mode to manual
3. msgbox to the user that the calculation is manual

In a BeforeClose macro:

1. msgbox to the user that the calculation mode is being re-set
2. set the calculation mode to the "remembered mode"

--
Gary''s Student - gsnu200802


"GD" wrote:

Hi, i have a large complex spreadsheet which is currently hosted on a shared
drive and accessed via emailed hyperlinks. The sheet is such that it takes
several minutes to calculate changes, and as such when multiple entries are
being made daily it poses a problem with several users waiting for it to
calculate and closing it or thinking it's encountered a problem - i've had to
shave 250+ complex formulas from considering rows 1-9999 to 1-7000 just to
get it to calculate without crashing at all.
Is there a way of turning off the automatic calculation for a central sheet
such as this, but still allowing casual input of data, so one person (namely
me) can update it last thing or first thing and take the calculation hit,
leaving things streamlined for others?
I've tried it in the tools menu but unfortunately turning it to manual
calculation appears only to apply to my machine..