VB 6.0 - Run a macro whenever any workbook(any excel file) is opend

How to trigger a macro whenever any workbook opens?
I have many excel files in different locations in my computer, I need a macro stored in PERSONAL.XLSB to auto run(be triggered) if any of the files are opened.

The closest thing I can suggest is the demo shown here:

http://www.mvps.org/vbvision/Sample_Projects.htm

Do a search on the page for "watch directory".