How do I hide the personal macro workbook? Perhaps I don't understand the question but any help you could give would be greatly appreciated.
Where do you want to hide it from?
If you want to remove it from your computer navigate to: C:\Users\%username%\AppData\Roaming\Microsoft\Excel\XLSTART and delete Personal.xlsb
Let me know if that is not what you were looking for.
Make sure that your personal macro workbook is the active workbook.
In the Window group of the View tab of the ribbon, click Hide.
Quit Excel. When you are asked if you want to save changes to your personal macro workbook, click Yes.
Next time you start Excel, your personal macro workbook will be opened hidden.