Excel Sheet opening

[sodapop]

Hi,

My company moves us the Office 365 and I have developed an issue. I have a personal workbook that has several macros in it and when I open another excel file the personal workbook opens first the the selected one opens. The issue I would like to fix is when the requested file opens it opens leaving the personal book visible in the background. I then have to move the requested workbook up to see the last couple of lines. Is there a way to have the requested workbook open on top of the personal one? It was not an issue in Excel 2016.


IE
personal workbook
new workbook

Thanks for the help.

I tried to insert a picture of what I am talking about but didn't see that as an option from my pc.

 

[Joe4]

Re: Excel Sheet opeining

I think you want to hide your personal macro workook altogether.
Have a look at these links:
https://www.groovypost.com/howto/stop-personal-xlsb-opening-excel/
https://excelribbon.tips.net/T012159_Automatically_Hiding_the_Personal_Workbook.html

 

[sodapop]

Re: Excel Sheet opeining

Thanks Joe!

 

[Joe4]

Re: Excel Sheet opeining

You are welcome.