Thread: Add-in security
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default Add-in security

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!