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

Asked By Gauss on 06-Sep-16 11:28 AM
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.
Robbe Morris replied to Gauss on 06-Sep-16 11:27 AM
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".