Extra excel window that will not close in excel 2013 pro

[dloskot]

I have a PESONAL.XLSB sheet with a common macro that is in XLSTART folder. When I open an excel sheet that has local macros and forms. (i.e. just for that sheet). Everything is fine to start with, I can click on the box to make the form open, the form works fine, but when I exit the form excel goes back to the main excel sheet but then opens two other blank sheets that are grayed out and I can't do any thing with them. I can't close them unless I hold the shift and click the X this closes all sheets. This does not happen on machines that have Excel 2010 pro. I have looked all over the internet and can not fine why this is happening. If I go back to the main sheet I have an second box to quite and if I click that and run the macro to shut down all copies of Excel close. If I just click the X the other two sheets stay open and the only way to them is to use the Shift Click of the X, then both close at once. If I open a sheet that doesn't have any local macros it no extra sheets are opened.

If I remove the Personal.xlsb file from XLSTART I don't have any problems.

If I open a file and just run the shared macro from Personal.xlsb there are no issue.

I have the exact same problem on three different systems. Does anyone have any suggestions?

Thanks Doug

 

[dloskot]

Ok this problem is officially driving me nuts. It appears that no one on the internet has a solution. In addition to what has been tried above I tried one more thing. I wrote the below macro and ran it from my main excel sheet that has the form I want people to use to enter data into Access. Before I run this macro if I do an unhide the only sheet to unhide is Personnal.xlsb. I run this macro and it successfully closes Personnal.xlsb. Then I open the from enter data and close the from and I get back to my make excel sheet but then there is a second blank / greyed out sheet that can not be unhidden, the unhide button on both the main sheet and the blank sheet are greyed out. Where the heck is this extra blank sheet coming from??????

I do not have this issue in Excel 2010 but I do with 2013. Can anyone come up with a solution???????

Windows("PERSONAL.XLSB".Active
ActiveWindow.Close savechanges: = False
[LEFT][COLOR=#222222][FONT=Verdana]

[/FONT][/COLOR][/LEFT]