Any ideas how to purge Personal.XLSB Workbook events so they fire?

[Gobshite]

None of my Personal.XLSB Workbook events fire
I have several VBA modules/routines in the same book that work fine
I'm on a network drive working from home and cant locate Personal.XLB
Any ideas how to purge Personal.XLSB Workbook events so they fire?
or any idea where i might find Personal.XLSB on a network drive?
or any method of making XL create a new one in a folder of my choice?

 

[rlv01]

It is unlikely that your PERSONAL.XLSB macro workbook will be on a network drive. It will be on your PC's local drive.

If you press 'Alt-F8' in a worksheet, then if a PERSONAL.XLSB macro workbook exists, all it's macros should be listed.

Usually (but not always) the file is found here VBA.Environ("AppData") & "\Microsoft\Excel\XLSTART\"

This macro will check for that folder:

Sub PersonalMacroWorkbookFileLocation()
    Dim XLStartFolder As String

    XLStartFolder = VBA.Environ("AppData") & "\Microsoft\Excel\XLSTART\"    
    With CreateObject("Scripting.FileSystemObject")
        If .FolderExists(XLStartFolder) Then
            Select Case MsgBox("Folder:" & vbCr & vbCr & XLStartFolder & vbCr & vbCr & "Open this folder?", vbYesNo, Application.Name)
                Case vbYes
                    VBA.Shell PathName:="C:\Windows\explorer.exe " & XLStartFolder, WindowStyle:=vbNormalFocus
                Case vbNo
            End Select
        Else
            MsgBox "Folder:" & vbCr & vbCr & XLStartFolder & vbCr & vbCr & "does not exist"
        End If
    End With
End Sub