May 18 2020 02:25 PM
I created a new macro and saved it in the personal macro workbook. The personal.xlsb file was saved out to XLSTART folder. But when I launch Excel it does not load the personal macro file so I can't see it or run thing from it. If I open the personal.xlsb file first by just double clicking it will open up Excel and I can see the personal macros. Can't figure out why it does not load automatically when Excel is launched.
May 19 2020 02:29 AM - edited May 19 2020 02:30 AM
Is it in the list of Disables Items perhaps? File, Options, add-ins tab, use drop-down near the bottom and select disabled items. Then click Go...
May 20 2020 12:04 PM
I solved the problem with a workaround. You can define a folder that contains files that will automatically open when you launch Excel. So I created a folder called EXCEL START and I put my personal.xlsb file in the folder and now it all works perfectly. I could never find out why it would not load from the normal location @tomrdillon1944
So setup a folder loading go to Options/Advanced/General and fill in the file path for the folder you want to use
May 20 2020 12:19 PM
Possibly a bad registry key.
May 21 2020 03:25 AM
Nov 01 2023 08:42 AM
Your reply worked for me!!!!!
Thank You.