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!