1. In excel, when I create macros in a workbook, I give the macro a name. when I save that workbook as another file, the macros do not work (warning message comes up to end or debug).
In checking out the macros, I find that they all have names that are preceded by the original file name ending with a punctuation mark. I have tried stripping the file name away with a "find and replace" procedure, but that does not work either. One copy of this file can no longer be opened and crashes. How can I create macro names that remain with the work book and not have extensions added to them? IE ("SortAll" not "Template1!SortAll").
2. In trying to save this file, I have deleted all macros, but upon opening the file, I get the warning about macros. How do I completely remove all macros so I do not get that message.
In checking out the macros, I find that they all have names that are preceded by the original file name ending with a punctuation mark. I have tried stripping the file name away with a "find and replace" procedure, but that does not work either. One copy of this file can no longer be opened and crashes. How can I create macro names that remain with the work book and not have extensions added to them? IE ("SortAll" not "Template1!SortAll").
2. In trying to save this file, I have deleted all macros, but upon opening the file, I get the warning about macros. How do I completely remove all macros so I do not get that message.