To be safe - how to check macro before run it?
 

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

To be safe - how to check macro before run it?
 

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:

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

--

Dave Peterson

To be safe - how to check macro before run it?
 

Thank you
Eric

"Dave Peterson" wrote:

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:

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

--

Dave Peterson