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!

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!

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!

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 -

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" wrote in message
...
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 -

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

Chris

On Mar 7, 12:25*am, "Jon Peltier"
wrote:
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" wrote in message

...
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 -- Hide quoted text -

- Show quoted text -