Hermesnunya
05-29-2008, 09:52 AM
We are trying to copy and paste a worksheet and every time we do this, Excel runs through the formulas. Is there a way to disable this?
Temporarily disable public functionsHermesnunya 05-29-2008, 09:52 AM We are trying to copy and paste a worksheet and every time we do this, Excel runs through the formulas. Is there a way to disable this? Cas 05-29-2008, 10:11 AM Yep: Manually: Tools->Options->Calculation->Manual VBA: Application.Calculation = XlCalculation.xlCalculationManual Just make sure to set it back to automatic eventually, otherwise people can get confused... ;) Hermesnunya 05-29-2008, 11:44 AM Yep: Manually: Tools->Options->Calculation->Manual VBA: Application.Calculation = XlCalculation.xlCalculationManual Just make sure to set it back to automatic eventually, otherwise people can get confused... ;) Awesome! That's exactly what we are looking for. Thanks! |
EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum