Lost access to all my macros in personal macro workbook

Try clocking on the Office Button at the top left of the window. Then
at the bottom of the pop-up window, under the recent documents list,
there is a button for Excel options.....click that button. Then on
the left, click on Add-in's. At the bottom of the Add-in page there
is a "Manage" drop down. Select Disabled Items from the "Manage" drop
down and hit GO. If Personal.xlsb appears there, enable it again and
it will startup when Excel starts up.

Sometimes a verbatim description of your problem works, so I Googled "personal macro workbook is not automatically loading when Excel starts" (no quotes, although it is quoted from your post) and found www.eggheadcafe.com/software/aspnet/30445352/personalxlsb-does-not-lo.aspx at #7 on the first page.

Other forums, and the first few posts on eggheadcafe, suggested fiddling with the personal.xlsb file but the post  I copied sounded more like the solution.

Despite it's unusual appearance, I've found good troubleshooting ideas on the eggheadcafe forum before.

In the past i've had this problem in various versions.

I got round it by renaming it, moving from it the folder (something like C:\microsoft\excel\xlstart depending on your system configuration)  opening it, then exporting all the modules, then closing it

Created a new personal.xl* with the recorder, then importing the modules. Then closied excel saving my newly created personal.xl*

 Restarted excel and all my macros were up and running.