Fix macro glitch in excel
My corporate computer was recently switched to Office 2019. Excel was opening just fine for me until I created a macro - now I'm getting a notification "personal.xlsb is locked for editing". I've tried the "share" option which allows me to unhide my personal file and enable my macro, however, upon closing and reopening excel, I get the same error message and have to go back and do this process again to enable the macro. There has to be a fix for this - I shouldn't have to go through this process every time.
I have save my macros on a personal file in excel under macros. but there are times that my list of macros disappears and I had been noticed it that I have to have a empty excel macro on the background calls "personal" to be able to see the list of macros. but now I can't figure out how to have this "personal" empty excel file on the background and I can't find my macro list either.