View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Héctor Miguel Héctor Miguel is offline
external usenet poster
 
Posts: 434
Default Why am I getting 2nd macro security warning?

hi, joe !

yes !, using =evaluate("...") in named-formulae is one of the ways excel 4 macros waring arises
as evaluate comes from the (ancient) XL-4 macro-functions (for those whom remembers that) language

glad to be in help (and thanks for your feed-back) <vg
regards,
hector.

__ previous posts __
however, "macros" in macrosheets are "named-ranges" (either as functions or commands)


I do not understand that, but that pointed me in the right direction.
Thanks!
Aha! Problem solved!

I had created a named formula of the form =EVALUATE("1+2+3").
When I deleted that, the "Excel 4.0 macro" warning went away(!).

Yup, that's it! When I create a new workbook (no macros, etc)
and add another named formula of the form =EVALUATE("..."), the warning returns.

I am surprised. Using =EVALUATE() in a named formula has been recommended before
in these newsgroups without any mention of an additional warning at load time.

Thank you very much for your patient troublingshoot tips.