Macros showing up in wrong WB

[mikecox39]

I have 2 workbooks, Personal and Office and they are not interchangeable. I can't seem to isolate the macro I created for each of them.


Each unique macros should only be accessible from it's relevant WB, but I'm doing something wrong because this is what I have this: https://app.box.com/s/z5z0rcp4xgd4vwfe1wgn

Also, I have lost macro code, I created a macro, renamed it but later, when I opened the WP found the macro name but an empty code pane. There doesn't appear to be a save option, I decided to click the save (disk) icon on the toolbar.

 

[mikecox39]

Here's the link to my Box folder and the workbook in question. I didn't remove the data, nothing there to protect.

I did have the macro on the Quick Access but it didn't work the last time so I removed it. I checked the Macro list again, to replace it, but it wasn't listed, as you can see.

https://app.box.com/s/z5z0rcp4xgd4vwfe1wgn

 

[jkpieterse]

Hi Mike,

The reason the macro is named this way in the macro's box is because you used the same name for the macro (sub BackupBudget) and the module the macro is in. If you change the name of the module to anything else, the module name and workbook name disappear form the dialog. Excel doesn't like duplication of names of things, best to keep them unique.

 

[mikecox39]

Hi Mike,The reason the macro is named this way in the macro's box is because you used the same name for the macro (sub BackupBudget) and the module the macro is in. If you change the name of the module to anything else, the module name and workbook name disappear form the dialog. Excel doesn't like duplication of names of things, best to keep them unique.

Thanks Jan, I'll create a different name and will not make that mistake again.