Use AutoCorrect upon Workbook_Open

[arfanvilla]

I am trying to run the AutoCorrect.AddReplacement feature within the Workbook_Open macro.

e.g.

Private Sub Workbook_Open ()

    Application.AutoCorrect.AddReplacement What:="y", Replacement:="Yes"
    Application.AutoCorrect.AddReplacement What:="n", Replacement:="No"

End Sub

The above does not work when the workbook has opened - however if the macro is run seperatly it works fine. I need the macro to run when the workbook is opened, any ideas thank you.

PS. When the document is opened on different PC's then the AutoCorrect will enable upon start up.