Monitoring

[serpex]

Hey All,

Windows Office 365 (Excel Version 2306)

I have taken over maintaining a global macro file that is stored in XLSTART so everyone in the office shares the same macros for every single excel sheet opened.

I want to be able to detect when a new xlsx/xlsm file is opened and record the filename, if it has a specific prefix it will execute some code specific to it.
I have made a module with auto_open() however the macro file in XLSTART launches first and executes the code before the actual file is opened.

Is what im trying to achieve possible?

 

[serpex]

Solved

Public WithEvents App As Application
Private Sub App_WorkbookOpen(ByVal Wb As Workbook)
    If Left(Wb.Name, 2) = "NP" Then
        MsgBox "NP Sheet: " + Wb.Name
    End If
End Sub
Public Sub Workbook_Open()
    Set App = Application
End Sub

 

[Peter_SSs]

When posting vba code in the forum, please use the available code tags. It makes your code much easier to read/debug & copy. My signature block below has more details. I have added the tags for you this time.