How do I make a hidden excel file to stop closing everytime i close another visible file?

[jskasango]

I have a hidden macro-enabled spreadsheet that i use with the menu ribbon to run the macros in it.
Most of the time when I close a file I am working with, when I try to use the macros to process another file, I discover that the hidden macro-enabled file has also closed itself.
How can I stop it from closing until I exit excel?

 

[S Oberlander]

I have that too
but I find that the shortcuts I put on the ribbon will just reopen the hidden file if it was closed

 

[jskasango]

I have that too
but I find that the shortcuts I put on the ribbon will just reopen the hidden file if it was closed

How did you get the shortcuts to do that? In my case the shortcuts return a runtime error and that when I realize the hidden file closed itself!

 

[S Oberlander]

How do you create the shortcuts on the ribbon?
And where is your file stored?

 

[jskasango]

How do you create the shortcuts on the ribbon?
And where is your file stored?

I use the "Customize Ribbon" option, then I select the "Menu Commands". The file is stored in the XlStart folder.

 

[S Oberlander]

.

 

[S Oberlander]

So that file is supposed to open automatically when excel is started.
Is it possible that this file was slowing down excel from opening so it was put on the disabled items list?

Try checking this post
I had this in the past and the above mentioned post got me out of the issue.