Excel doesn't have event-driven capabilities for folder monitoring. What you could do, however, is change the name of your PrintFolders macro to Auto_Open, so it runs automatically every time the workbook is opened.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|