personal workbook keeps opening. How do i stop it

[cwilliams96]

I recorded a few macros. and saved them in my personal workbook. Each time i open a spreadsheet, even if it doesnt contain macros, the workbook opens, but so does a personal workbook. This never happened before.

Any ideas how to stop it, or why does it do it?

 

[BuddieB]

because the personal.xls file is in your XLStart folder, whcih contains files that are automatically opened every time you start excel.

you have to move your personal.xls file out of this folder if you dont want it to open every time you start excel.

one other option though is to add the following AUTO_OPEN maco to your personal.xls file, so that when it opens, it is automatically hidden in the background and you can still have acess to the macros in the file.

Sub Auto_Open()
    Windows("Personal.xls").Visible = False
End Sub

 

[cwilliams96]

how do i find the startup folder to move the personal workbook

 

[Legacy 21301]

The next time you open XL :-
With the Personal .xls workbook as the active window go to Window>Hide, and then close XL and click Yes when asked if you want to save the changes to Personal.xls

 

[Legacy 21301]

how do i find the startup folder to move the personal workbook

Try using the Windows' Search tool.

 

[2Tigers]

Thanks Ponsy Nob. This really helped me as well

2Tigers

 

[jmarty21]

The next time you open XL :-
With the Personal .xls workbook as the active window go to Window>Hide, and then close XL and click Yes when asked if you want to save the changes to Personal.xls

Thank you for this!!

 

[willow-mouse]

This didn't work for me, it just opens a second grey window with the personal.xlsb workbook hidden now

 

[picculver]

I recorded a few macros. and saved them in my personal workbook. Each time i open a spreadsheet, even if it doesnt contain macros, the workbook opens, but so does a personal workbook. This never happened before.

Any ideas how to stop it, or why does it do it?

I was having the same issues and it was getting very irritating. I think I just fixed it by disabling a date picker app that I had enabled as an add-in. Found it by accident but it seems to be working now. I would check any Add-In that you have checked.

Good Luck. I know it's very frustrating, I've been dealing with it for two months now on a daily basis.