software

Someone sent me a excel file with macro, how can I check what the macro does
before run it?
Thank you in advance
Eric

Open the file with macros disabled
(change your security setting via tools|macro|security|security level
to high)

Then open the workbook

Then go to the VBE (alt-f11) and look at the code in the project.

If the project is protected, then you'll be stuck trusting or not trusting the
source.

Remember to toggle the macro security setting back the way you want it when
you're done.
Eric wrote:
gt;
gt; Someone sent me a excel file with macro, how can I check what the macro does
gt; before run it?
gt; Thank you in advance
gt; Eric

--

Dave Peterson

Thank you
Eric

quot;Dave Petersonquot; wrote:

gt; Open the file with macros disabled
gt; (change your security setting via tools|macro|security|security level
gt; to high)
gt;
gt; Then open the workbook
gt;
gt; Then go to the VBE (alt-f11) and look at the code in the project.
gt;
gt; If the project is protected, then you'll be stuck trusting or not trusting the
gt; source.
gt;
gt; Remember to toggle the macro security setting back the way you want it when
gt; you're done.
gt;
gt;
gt;
gt; Eric wrote:
gt; gt;
gt; gt; Someone sent me a excel file with macro, how can I check what the macro does
gt; gt; before run it?
gt; gt; Thank you in advance
gt; gt; Eric
gt;
gt; --
gt;
gt; Dave Peterson
gt;