MrExcel Publishing
Your One Stop for Excel Tips & Solutions

how can I determine if an excel file contains macros or not?


Posted by Julian on May 03, 2001 9:21 AM

how can I determine if an excel file contains macros or not? I saw this code on the web once, but couldn't find it now. Please help, thank you so much!


Posted by Kevin James on May 03, 2001 12:44 PM

Have you tried:
Tools / Macro / Macros

Posted by Julian on May 03, 2001 3:01 PM

Can this be done by a Macro - to go thru all the excel files on my hard drive and find out all the files that have macros.