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

jae113

Board Regular
Joined
Jun 17, 2008
Messages
227
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!
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

jae113

Board Regular
Joined
Jun 17, 2008
Messages
227
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

Board Regular
Joined
Jun 17, 2008
Messages
227
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,561
Messages
5,596,849
Members
414,107
Latest member
Tigretto

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top