Calculation is not worksheet specific. It's not even workbook specific. It's
an application setting.

So you can turn calculation to manual and recalc when you want to
(tools|Options|calculation tab|calc now.

=====
But depending on what version of excel you're running, you can actually turn
calculation off for specific worksheets.

worksheets("Sheet1").EnableCalculation = False

IIRC, this was added in xl2002.

But you'll have to turn it back on before calculating--even hitting F9 won't
help.



nobbyknownowt wrote:

I had a play and went with enable events, thanks

The sheet is designed for other users and I need to keep it a simple as
possible

However I have now found a glitch

There are 4 seperate worksheets in te workbook and 4 seperate
calculate events. When I activate a worksheet and start completing it
a calculate event from another sheet sometimes stalls the program.
How do I make the calculate event sheet specific?

cheers
Nobby

--
nobbyknownowt

--

Dave Peterson