View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ayo Ayo is offline
external usenet poster
 
Posts: 489
Default Help with Workbook Calculation

I want to set the calculation option for my ActiveWorkbook to Manual. How do
I accomplish that without using the code below which set the option for all
open workbooks?

Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
End Sub