Try starting your file in Safe Mode (select the file, hold down CTRL key then press Enter) and once opened debug your macros to find when and what closes your file. If present start from the WorkBook_Open (or Auto_Open) macro.

__________________
Difficult is not to know but to share what you know (Han Fei Tzu reworked)