Forum Discussion
Gareth_Whitehead
Sep 12, 2020Copper Contributor
Excel Workbook
Hi I have Microsoft 365. When I right click on the Excel button on the taskbar at the bottom, to select which workbook I want to open. A ‘personal workbook’ always opens separately as well. How c...
HansVogelaar
Sep 12, 2020MVP
You probably created a personal macro workbook (Personal.xlsb). This workbook contains macros that will be available in all workbooks.
Activate the personal macro workbook, then click Hide in the Window group of the View tab of the ribbon.
Then quit Excel, and answer Yes when you're prompted to save changes to your personal macro workbook.
Next time you start Excel, the personal macro workbook will be loaded invisibly.
- Gareth_WhiteheadSep 12, 2020Copper Contributor
Hello Hans
Thank you for your reply, it is appreciated. It doesn’t matter whether it is a macro workbook or not. Tried both (.xlsm and .xlsx) I get the same result.
Rgds
Gareth