Personal.Xlsb Workbook.Activate not working

I'm trying to get a macro working in the personal workbook that I've done before, but for some reason it's not working now.

What I need is when a workbook has sufficiently loaded (or activated), for the macro in the personal xlsb to run.
At the moment, I'm putting the code in the This Workbook part of the personal xlsb and the following works fine:

Private Sub Workbook_Open
msgbox ("test")
End Sub

But if I replace Workbook_Open with Workbook_Activate, the message box doesn't pop up.

Suggestions on how to get this working please?

The Personal workbook is hidden so will never be active, therefore the activate event won't fire.

Are you trying to run the macro when any workbook activates or specifically after the personal macro workbook is loaded?

Then you need an application-level event sink.

Private WithEvents app as Excel.Application
Private Sub Workbook_Open
Set app = Application
End Sub
Private Sub app_WorkbookActivate(ByVal Wb As Workbook)
    If Instr(1, wb.name, "some text", vbtextcompare) > 0 then wb.sheets("sheet name").select
End Sub

for example.

Glad to help.