I will present you a free tool, to find macros.
Easy macros is a simple and easy-to-use tool, which requires neither installation nor admin rights,
Browse your local folder or network directory to Finding excel files contains macros (VBA)
You can also choose to filter from the last access date to optimize the search
This tool use the SAFEMODE memory, your files excel is not open in the system and macros not be executed.to prevent any risk to run.