Macro problems

[m. silva]

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.

 

[Joe4]

1. The macros really aren't saved with the name "Template1!SortAll", they are saved with the name "SortAll". If you have multiple files open in Excel, it just shows which workbooks the macros are saved in by showing the name preceding the macro.

Think of it like referencing a cell on a different worksheet. If you go to Sheet 2, and in a cell enter "=" and then choose on cell on Sheet 1, Excel will enter "Sheet2!A1".

In your code, do you have any references to the name of the file? That would cause errors if you changed the name of the file and tried running the macro. Post you code if you still need help with this.

2. You must also delete the module that held the macro. In the Vb editor, highlight the module, right click, and select and select "Remove Module1"

 

[m. silva]

jmiskey
Thank you for the help. I have not yet attempted to fix my no 1 problem.
Regarding no. 2, I deleted the modules as you suggested, however, when I reopen the workbook, I still get the macro warning box. Any other suggestions?

 

[Joe4]

Are you sure you deleted all the macros out of the ThisWorkbook and Sheet modules also?

Also, verify that in the VB Project Explorer, you should no longer see a folder named "Modules" for that file.