Excel 4.0 Macro Warning On Open

  • I keep getting this warning. I temporarily used a 4.0 macro, but found a better way to do it, so I no longer am using that function. How do I remove whatever it is that is calling it so that user's don't have to see this message. There is a small probability that something else somewhere is calling a 4.0 command, but I have no idea how to find out what that is.
    Thanks.
    [Blocked Image: http://img236.imageshack.us/img236/5021/toolbar1kr3.jpg]
    I've checked the references, and excel 4.0 Macro's aren't listed, and I'm pretty sure they were before when I was using them.[Blocked Image: http://img152.imageshack.us/img152/1207/toolbar2la3.jpg]

  • Re: "excel 4.0 Macro" Warning


    The function you are no longer using must be either an Excel add-in or a custom function. You will have to go into the VB Editor and manually delete any modules with code or remove the add in.

  • Re: "excel 4.0 Macro" Warning


    Quote from AAE

    The function you are no longer using must be either an Excel add-in or a custom function. You will have to go into the VB Editor and manually delete any modules with code or remove the add in.


    Thanks for the reply. Unfortunately, it's not an Excel add-in:
    [Blocked Image: http://img49.imageshack.us/img49/9764/toolbar3ub4.jpg][Blocked Image: http://img182.imageshack.us/img182/2158/toolbar4dy2.jpg]
    Re: a custom function, if it is, I have no idea which one. I have over 2500 lines of code in this workbook, so going through every line to find it is not a trivial matter, not to mention that I don't even know what to look for.

  • Re: "excel 4.0 Macro" Warning


    Do you have any defined names using XLM4 functions? Such names could use XLM4 like GET.CELL and GET.DOCUMENT. If you want to search in code, then you just need to search for the text "ExecuteExcel4".


    Richard

  • Re: "excel 4.0 Macro" Warning


    Quote from RichardSchollar

    Do you have any defined names using XLM4 functions? Such names could use XLM4 like GET.CELL and GET.DOCUMENT. If you want to search in code, then you just need to search for the text "ExecuteExcel4".


    All 1352 names that are in the workbook seem to be valid. (ex: "=Standard!$D$98"). I did a search through the workbook, and there were no 'get' references in either the values or forumulas. Also, a search for "execute" in the code did not return anything, neither did "excel4" or even "excel" (other than the word "excel" in 1 comment line).
    Thanks for the ideas though.

  • Re: "excel 4.0 Macro" Warning


    There are a number of other XLM4 functions that can be used in defined names like EVALUATE and LINKS (in fact there are an awful lot of them). Are you also searching in hidden workbook names? If not, then checking any such names may be worthwhile too...

  • Re: "excel 4.0 Macro" Warning


    Quote from RichardSchollar

    Are you also searching in hidden workbook names? If not, then checking any such names may be worthwhile too...


    Well there you go. Thanks a bunch. There was one with a get.document name.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!