Testing for Code in a Workbook
 

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

--
Bill @ UAMS

Testing for Code in a Workbook
 

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


On Aug 21, 2:29*pm, BillCPA <Bill @ UAMS wrote:
If I open a workbook in a macro, how do I check that workbook to see if it
contains VBA code?

--
Bill @ UAMS

Testing for Code in a Workbook
 

This should help you get started

http://www.cpearson.com/excel/vbe.aspx
--
HTH,
Barb Reinhardt



"BillCPA" wrote:

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

--
Bill @ UAMS

Testing for Code in a Workbook
 

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