May 18 2020 01:53 PM
I created a new macro and stored it in the personal macro workbook. When I open the XLSTART folder I see the personal.xlsb file with the correct time stamp. But when I shut down excel and reopen it the personal.xlsb does not load and so when I go to run a macro from it excel does not show it as being available. If I shut down excel, then double click on the personal.xlsb file it opens excel and I now see the macros. So what has me stumped is why it is not automatically loading when I start up excel. I have checked all the setting and all macros are enabled, etc.
May 21 2020 09:38 PM
Can you please try doing the following
1. Back-up your personal macro workbook (PMW)
2. Create the new workbook & make new PMW
3. copy the codes from your back-up PMW and paste into new one.
hope this should fix the issue
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more
Nov 13 2020 11:11 AM
@Faraz Shaikh I have at least 20 modules of code to copy from old personal.xlsb to the new file. Is there a quick way to do that?
Nov 15 2020 01:57 AM
Hi @ToesInTheSand,
Check this blog might be helpful by Ron https://www.rondebruin.nl/win/s9/win002.htm
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.