With Application Not Triggering

Copper Contributor

I've got some code to turn on iterative calculations in a Personal Macro workbook (currently on the ThisWorkbook page; I've moved it between that and Modules). The code that I'm using is below - has anyone else run into this issue and / or does anyone have feedback on where the error in the code is?

 

Private Sub Workbook_Open()

' Set maximum iterations to 9,999

    With Application

    .Iteration = True
    .MaxIterations = 9999
    .MaxChange = 0.001

    End With

End Sub

 

After I updated to Windows11 I started running into broader issues with my Personal workbook and am not really sure what to do. 

0 Replies