Tom, like Ron points out, I don't want to turn macro security off ...
I am just wondering if there's a way that I can tell Excel that add-
ins stored in /application data/microsoft/addins are OK and that I
don't need a pop-up to allow those....

Chris

On Mar 6, 3:23*pm, "Ron Coderre" wrote:
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
hehttp://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!- Hide quoted text -

- Show quoted text -