View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Detect macros in an Excel file

Added in xl2007?

--
Regards,
Tom Ogilvy

"Ron de Bruin" wrote in message
...
You can use this to test it

If ActiveWorkbook.HasVBProject then ...............

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gleam" wrote in message
...
I am using macros in one file to audit another file. The second file
should not have any macros. Is there a way I can detect this?