Forum Discussion
Personal.xlsb Workbook Keeps Opening
Hi Don,
When you open Excel select the Personal Macro Workbook and go to:
View >> Window >> Hide
After that, close Excel, and you will face a message asking you to save the changes you made to the Personal Macro Workbook, click Save.
Worked, thanks!
Thanks! It Works!
Haytham Amairah you rock!
Haytham Amairah This unfortunately did not work for me, because my Personal.xlsb file was "read only" access. It wouldn't save that it was "hidden" even though the file wouldn't just show up like a regular Excel file. I had to save it under a different directory (I used Downloads for easy access), closed out Excel, deleted the read only file in the XLStart folder, and moved the new editable personal.xlsb file into the XLStart folder so it would open in the background instead of opening every time I opened an Excel File. I couldn't do a Save As and just overwrite it, because it had to be open to do that, and it wouldn't let me save over an open document.
Thank you for the feedback, because you actually gave me the "Well duh" moment I needed to do a save s to a different directory. LOL!
slmetcalftx Where/how did you get a "new editable personal.xlsb file" ??
UFBarbi Unhide the file and then do "save as" under a different directory. That will give you a new file that you can open and edit and save. You have to delete the old file under XL Start and move the new file over to XL Start for it to work properly. Hope this helps you!
- Wait, so did you figure it out?
- Quick and easy, thank you.
