How would a folder have any knowledge of/connection to Excel ?

You could provide a BrowseForFolder dialog in Excel, then ... do something.
http://vbnet.mvps.org/code/browse/browsefolders.htm

NickHK

"Clarissa" wrote in message
...
Is there a way to execute a macro by clicking open a folder in the file
directory?