Can I calculate a single page ONLY?

Can I calculate a single sheet only, and disable calculation update on other
sheets? I have several sheets that take a few seconds (too long, in my case)
to re-calculate where I'm running a macro that plugs a value into a cell and
gets an answer, plugs another value in and gets an answer, etc. I'd like to
calculate only the sheet where where the calculations are actually being
affected-I'm not concerned with the other sheets.

Thanks
DH

Excel 2003 & 2007 (at least!) have the option to calculate only the current
sheet. Calculation must be set to Manual first. In XL2007 select Formulas
ribbon Calculation section Calculate sheet. In XL2003 select Tools
Options Calculation tab Calc Sheet. In either version the VBA command
is:

ActiveSheet.Calculate

Hope this helps,

Hutch

"dh13134" wrote:

Can I calculate a single sheet only, and disable calculation update on other
sheets? I have several sheets that take a few seconds (too long, in my case)
to re-calculate where I'm running a macro that plugs a value into a cell and
gets an answer, plugs another value in and gets an answer, etc. I'd like to
calculate only the sheet where where the calculations are actually being
affected-I'm not concerned with the other sheets.

Thanks
DH