If you never load a workbook other than those you create yourself you can
get away with enabling all macros.

Those you get from the 'net or from other persons could pose a risk of
malicious code.


Gord Dibben MS Excel MVP

On Tue, 16 Mar 2010 13:32:58 -0700, "Robert Crandal"
wrote:

Just curious, but what are some reasons for "NEVER" enabling all
macros?? I only use macro enabled workbooks that I personally
create. I also expect my macros to run immediately or automatically
without any reminders or warnings that a macro is about to run
or whatever.

thank you

"Bob Phillips" wrote in message
...

You should NEVER enable all macros, just too risky.

Have you tried putting it in a trusted location and running it from there?

--