Testing for Code in a Workbook

[BillCPA]

If I open a workbook in a macro, how do I check that workbook to see if it
contains VBA code?

 

[Susan]

if you set your security to medium before you open it, it will bring
up the warning that the workbook contains macros, & do you want to
enable them?

susan

 

[Barb Reinhardt]

This should help you get started

http://www.cpearson.com/excel/vbe.aspx

 

[ward376]

Chip Pearson has a function you may be able to use, see Testing If A
VBComponent Exists at:

http://www.cpearson.com/excel/vbe.aspx

Cliff Edwards