Checking for existence of macros or code in an Excel Spreadsheet

  • Thread starter Thread starter Youssef Mourra
  • Start date Start date
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
 
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
 
Back
Top