Personal workbook macros and macro modules and macro calls

[SBF12345]

Greetings,

I have a macro that calls other macros. in past times I was able to run the parent macro and have the called macros work as intended. I am running into a problem now. For some reason I have macros in the 'macro' window titled as "PERSONAL.xls [then the module name].macro name". Prior to recently I had all macros titled only with PERSONAL.xls and then the macro name. My question is why the module name is now being included, and how can I remove the module component so that my macro calls work as intended.

 

[Trevor G]

Since 2007 the personal workbook has a file extension of .XLSB, what version of Excel are you using and have the macros been added in the Personal Workbook from an old version which you kept the Personal Workbook from?

 

[RoryA]

If you see the module name, it generally means that you either have another macro by the same name in another module, or you have given the macro and module the same name.

 

[SBF12345]

I am running 2003 and all the macros were built on 2003...I was receiving an error, something like 'can't open two PERSONAL workbooks' or something. I had been manually opening the personal workbook for many months, and then more recently I was receiving the error when I tried to open the personal.xls. I am 99.9999999 percent certain I didn't name the macro with the module name included. Perhaps the macros were saved somewhere else accidentally (other workbook?).