I am looking for an answer to the original question.

I have a worksheet containing a list of hundreds of users' workbooks on
a number of network servers. I want to identify which contain VBA code
and which don't. Later it will be my job to test that they run in our
new company environment (Office 97 - Office XP; Windows 2000 -
Windows XP). This is only the first of such lists, and will be
looking at potentially thousands of workbooks over the next couple of
months.

Rather than open them all up manually, I wrote a simple procedure to
scan through the list of paths, open each workbook, sum up the
CountOfLines in each CodeModule, then close the workbook. I will run
this overnight, and come back tomorrow and focus on the workbooks that
contain vba code.

I do not want to execute macros when I open each workbook.
OK... Solution : turn off events as suggested above

This worked fine, until my application started opening workbooks with
references to some obscure fiancial libraries that some users have
installed that I don't have. The Workbook_Open doesn't run, but Excel
still tries to COMPILE the code. The compilation fails, shows me the
errant line of code in the user's workbook. Neither disable events nor
disable alerts stops this. I really want to disable macros completely
when I open up each workbook. But I still want to be able to count how
many lines of code....


--
ScottDK
------------------------------------------------------------------------
ScottDK's Profile: http://www.excelforum.com/member.php...o&userid=16393
View this thread: http://www.excelforum.com/showthread...hreadid=248696