Add-in security

[cht13er]

First off, thanks to Jon Peltierfor the super easy-to-follow code
here: 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!

 

[Tom Hutchins]

Change your macro security setting to Low. Tools >> Macro >> Security >> Low
(on the Security Level tab) >> OK

Hope this helps,

Hutch

 

[Ron Coderre]

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)

 

[cht13er]

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

 

[Jon Peltier]

If the file is in fact an add-in, you can install it (Tools menu > Add-ins >
Browse etc.), and then it will not bother you again. The act of installing
it counts as approving it every time Excel starts, for as long as it's still
approved.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


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

 

[cht13er]

AHA! Thanks, that's what I was looking for!!! Now I owe you x2

Chris