VBA - automatically run when any workbook is opened

user_5298189 0
Viewed 1884

I want a Sub in my PERSONAL.XLAM file to run every time any workbook is opened. The following works, but only when opening a workbook when no other workbook is open.

Private Sub Workbook_Open()
MsgBox "Hello."
End Sub

How can I make this work upon opening additional workbooks?

vba excel
1 Answers
Related