Manual calc for one sheet, auto calc for another

H

Hall

Is it possible to set one sheet to manual calculation and another sheet to
auto calculation, in the same workbook?

Thanks
 
E

Earl Kiosterud

Hall,

No. It's not even possible to set it differently for two workbooks. Stranger than fiction.
You could do it with a Sheet_Activate sub in the ThisWorkbook module.

--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting. But if you bottom-post
to a reply that's already top-posted, the thread gets messy.
When in Rome...
 
Top