F9 Manual Recalculate only for one workbook
Thank you, this is somewhat helpful.
However, "Of course, if you have other
workbooks open at the same time, you won't be able to do any calculations
unless you do them manually." unfortunately reduces effectiveness, since I
usually have the worksheet in question open.
Isn't there a way through VBA or otherwise to restrict F9 only to one (or
several) chosen workbooks, while not "polluting" the other non-chosen
workbooks?
Thanks.
"Barb Reinhardt" wrote:
Press Alt F11.
Select the ThisWorkbook module for the VBA project your editing.
Paste this in.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.Calculation = xlCalculationAutomatic
End Sub
Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
End Sub
--
HTH,
Barb Reinhardt
If this post was helpful to you, please click YES below.
"Tenacity9" wrote:
Setting Tools-Options-Calculation to manual (ie, have to use F9) changes the
preference for all open workbooks in Excel 2003.
If you only want manual recalculation to apply to a particular workbook
permanently (in other words until the preference is changed back to
automatic), but other open workbooks and all new workbooks to be calculated
automatically (ie, no F9), is there a way to accomplish this easily?
Thanks.
|