Excel Workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-1660799%22%20slang%3D%22en-US%22%3EExcel%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1660799%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%20have%20Microsoft%20365.%26nbsp%3B%20When%20I%20right%20click%20on%20the%20Excel%20button%20on%20the%20taskbar%20at%20the%20bottom%2C%20to%20select%20which%20workbook%20I%20want%20to%20open.%26nbsp%3B%20A%20%E2%80%98personal%20workbook%E2%80%99%20always%20opens%20separately%20as%20well.%26nbsp%3B%20How%20can%20I%20switch%20this%20off%2C%20and%20open%20the%20sheet%20I%20have%20selected%20only.%26nbsp%3B%20I%20don%E2%80%99t%20have%20this%20problem%20on%20my%20works%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERgds%3C%2FP%3E%3CP%3EGareth%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1660799%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1660914%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1660914%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F791442%22%20target%3D%22_blank%22%3E%40Gareth_Whitehead%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20probably%20created%20a%20personal%20macro%20workbook%20(Personal.xlsb).%20This%20workbook%20contains%20macros%20that%20will%20be%20available%20in%20all%20workbooks.%3C%2FP%3E%0A%3CP%3EActivate%20the%20personal%20macro%20workbook%2C%20then%20click%20Hide%20in%20the%20Window%20group%20of%20the%20View%20tab%20of%20the%20ribbon.%3C%2FP%3E%0A%3CP%3EThen%20quit%20Excel%2C%20and%20answer%20Yes%20when%20you're%20prompted%20to%20save%20changes%20to%20your%20personal%20macro%20workbook.%3C%2FP%3E%0A%3CP%3ENext%20time%20you%20start%20Excel%2C%20the%20personal%20macro%20workbook%20will%20be%20loaded%20invisibly.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 can I switch this off, and open the sheet I have selected only.  I don’t have this problem on my works Excel.

 

Rgds

Gareth

2 Replies

@Gareth_Whitehead 

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.

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