Checking for existence of macros or code in an Excel Spreadsheet

Y

Youssef Mourra

Hi everyone,

I was wondering if there is a quick or easy way of
checking whether a file has any code or macros attached to
it?

thanks for your help in advance,

regards, Youssef
 
J

John Wilson

Youssef,

The easiest way would be to set your security level to Medium
Tools/Macro/Security
If there's code, you'll be prompted to enable it. If not, the workbook
will just open up without the prompt.
That's not to say that there couldn't be an empty module in the workbook

with no code as that would give the prompt too.

John
 
Y

Youssef Mourra

John, thanks for this. I'm going to work it out with that
information.

regards,
 
Top