Macros, How do I know what they do if I didn't create them.

[Abelg]

I deviced a workbook that consists of 8 worksheets. The worksheets contain
cells with formulas that are locked and hidden. They only show values. I
did not purposely create any macros for this workbook. However, everytime I
open it, I get a message asking me to Enable or Disable macros before
starting up.

If I enable the macros, is there a way to see what code they contain. How
do I know if it contains a virus. I keep my virus scanner pretty well
updated. I've scanned this workbook for viruses and nothing comes up.

Now I am in need of creating a legitimate macro to run in this workbook, but
I wouldn't be able to run it if macros are disabled in the beginning.

Respectfully,
Abel G.

[Bob Phillips]

Abel,

See http://www.contextures.com/xlfaqMac.html#NoMacros which will tell you
how to initially get rid of them all.

--
HTH

Bob Phillips

"Abelg" <Abelg@discussions.microsoft.com> wrote in message
news:9054BDD0-0D81-49A4-B940-800D848E670B@microsoft.com...
> I deviced a workbook that consists of 8 worksheets. The worksheets
contain
> cells with formulas that are locked and hidden. They only show values. I
> did not purposely create any macros for this workbook. However, everytime
I
> open it, I get a message asking me to Enable or Disable macros before
> starting up.
>
> If I enable the macros, is there a way to see what code they contain. How
> do I know if it contains a virus. I keep my virus scanner pretty well
> updated. I've scanned this workbook for viruses and nothing comes up.
>
> Now I am in need of creating a legitimate macro to run in this workbook,
but
> I wouldn't be able to run it if macros are disabled in the beginning.
>
> Respectfully,
> Abel G.