Forum Discussion
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 ...
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?
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.
- 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
