B BillCPA Aug 21, 2008 #1 If I open a workbook in a macro, how do I check that workbook to see if it contains VBA code?
S Susan Aug 21, 2008 #2 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
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
B Barb Reinhardt Aug 21, 2008 #3 This should help you get started http://www.cpearson.com/excel/vbe.aspx
W ward376 Aug 21, 2008 #4 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
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