Open a new workbook and activing formula only in a sheet

[Nelson78]

Hello everybody.

When I open the workbook, I need to inactive all formulas except in a specific sheet.
I've composed the following code, but unsuccessfully.

Private Sub Workbook_Open()
   
Application.Calculation = xlManual
Application.CalculateBeforeSave = False
    
    Worksheets("Second sheeet").Calculate

End Sub

What's wrong?

 

[Nelson78]

No way, unfortunately.

Private Sub Workbook_Open()

    Application.Calculation = xlManual
    Application.CalculateBeforeSave = False

Worksheets("Second sheet").Enablecalculation = False

End Sub

 

[Nelson78]

Maybe in "This workbook" I've to inactive formulas in the entire workbook:

Private Sub Workbook_Open()
    
    Application.Calculation = xlManual
    Application.CalculateBeforeSave = False
    
End Sub

And for the only sheet in which the calculation has to be automatic, I've to write some code in the related "Sheet".

Could this be the right way?