Hoping someone can help. I've got some code that copies a couple of sheets within my main workbook into a new workbook, and saves the new file. Just a simple SaveAs:
The sheets I copy over to the new workbook to be saved contain a number of macros, all of which function fine except for one small problem: they modify the old workbook and not the new one!
All of the macros are contained within the sheet code and not modules, and I even have code referencing the new wb in all of the relevant macros, like this:
Etc, which causes some of the macros in the new sheet to function properly, but is a pretty inelegant solution, and other macros still perplexingly reference the old wb.
When I look at the macros assigned to my my buttons I see the macro name as being the following:
2015-02-19 11-40-54 AM.jpg
So as opposed to being simply "Sheet1.home_" or even "MyNewWorkBookName!Sheet1.home_" it's still referencing the old workbook in every macro in the new workbook (Job Aid Creator being the name of the old workbook).
Is there any way to make this work before / after copying the sheets over and saving the new workbook?