howto find excel files that includes macro

  • Thread starter Thread starter umutgumus
  • Start date Start date
U

umutgumus

I have alot of excel files and some of them includes macro, Iwant to
find macro containing excel files, or delete all macros.. is there any
simple way to find them (a special search maybe..??), or must I open
all files and look for macro??
thanks..
 
I imagine there is some way to automate the hunt but I don't know it.
What I would do is set the Security level to Medium (Tools - Macro -
Security). Then open every file, one at a time. Any file that has any code
in it or that has just an empty regular module sheet will trigger the query
"Do you want to open this file with macros enabled........." or something
like that. At least this would limit the number of files you have to get
into. HTH Otto
 
Back
Top