Hi

At present I am running a macro which list the files in a specified
directory on a worksheet using the following events,

Sub Worksheet_Activate()
Sub Worksheet_SelectionChange(ByVal Target As Range).

Can I run the macro whenever a file is saved to this directory?

Thanks.