Please be aware that if you set your security settings to "Low", that
setting will apply to ALL Excel files. You will NEVER be prompted to allow
macros....they will simply load without your explicit consent. If there are
malicious macros in the file, they will load...engage...and do their damage.

Personally, I'd rather get the occassional prompt and know that only files I
trust will be allowed to run macros.

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Tom Hutchins" wrote in message
...
Change your macro security setting to Low. Tools Macro Security
Low
(on the Security Level tab) OK

Hope this helps,

Hutch

"cht13er" wrote:

First off, thanks to Jon Peltierfor the super easy-to-follow code
he http://peltiertech.com/Excel/menus.html ... I use it in an add-
in to call up two tools - a specialized text formatting tool and a
"find and highlight duplicates" tool.

Here's my question - every time I start up excel and go to use my
tools, the little "do you want to enable macros" box pops up.

Does anyone know how to get around this?

Thanks a lot!