PERSONAL wb errors: Names look like PERSONAL.xlsb!Basic_Print.Basic_Print and shortcuts don't work

[jae113]

Hi All,


I had a bit of sort code go wrong and my PERSONAL workbook where I stored all my macros was curropted and I had to start over. Luckily I had backup files of most of the VBA code!

But, ever since, all of my workbook names are funny - with $ and being there at least twice (PERSONAL.xlsb!Basic_Print.Basic_Print) and I can't use the keyboard shortcuts.

Any suggestions?

Thanks!

 

[jae113]

I'm reposting this because it was late in the day yesterday when I originally posted. Just trying to get more eyes on it!

 

[jae113]

I found this answer for the macro file names:

apparently if the module name and the sub name are the same, XL feels the need to include the whole path. I modified the name of my module slightly, and now I just
have the macro name in all cases.

My shortcuts are all working again finally as well!