Hi there,

I've got a macro which is designed to activate or open a wb.
The "Open" code is performed by an error handler.

However, if an error occurs here how can I handle it?

I've only recently started with error handling so please forgive my lack of knowledge
Sub Activate_or_Open_pINFO_2()

    Dim sName As String
    Dim OpenPATH
    sName = Range("C3")
    OpenPATH = ThisWorkbook.Path
    

        On Error GoTo ErrorHandler
        Workbooks(sName & ".xlsm").Activate
    Exit Sub

ErrorHandler:
On Error GoTo err1
Workbooks.Open FileName:=OpenPATH & "\" & sName & ".xlsm", _
                    UpdateLinks:=True
Exit Sub

err1:
MsgBox "The property info sheet is not available. It may have been deleted or moved from the file directory."

End Sub