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
_______
"cht13er" <(E-Mail Removed)> wrote in message
news:c28d0247-9440-4933-9afd-(E-Mail Removed)...
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" <roncode...@bigfoot.com> 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" <TomHutch...@discussions.microsoft.com> wrote in message
>
> news:35092DBF-04A2-4EDE-BC5B-(E-Mail Removed)...
>
>
>
> > 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
> >> 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!- Hide quoted text -
>
> - Show quoted text -
Similar Threads
