Forum Discussion

Copper Contributor

May 18, 2020

personal.xlsb file not loading when Excel starts up

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 ...

MVP

May 22, 2020

Hi tomrdillon1944

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

ToesInTheSand
Copper Contributor
Nov 13, 2020
ExcelExciting 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?
- ExcelExciting
  MVP
  Nov 15, 2020
  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.
  - Boguslaw_Reszka
    Copper Contributor
    Apr 30, 2024
    Hello,
    unfortunately, I experience the same phenomenon: after start of excel (for 365 MSO), macros from PERSONAL.XLSB are invisible. They are visible after doubleclick on PERSONAL.XLSB.
    However, when I try to use Edit button from Developer/Macros menu, it results with "Cannot edit macro on a hidden workbook. Unhide the workbook using the Unhide command."
    My PERSONAL.XLSB hasn't hidden status.
    I've overwritten PERSONAL.XLSB already, without the result - it doesn't start still.
    Unfortunately Ron de Bruin has closed his blog and I didn't found any other solution in web.
    Could you please share any tip for that?
    Thanks
    Boguslaw

Share

Resources