Checking for existence of macros or code in an Excel Spreadsheet

[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

 

[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

 

[John Wilson]

Youssef,

Found this little tidbit from Earl Takasaki posted back
on 3/28/2002.
http://makeashorterlink.com/?H19362C75
It's a little involved but he gives a good explanation of how
to code it and make it work.

John

 

[Youssef Mourra]

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

regards,