Solved: issue with excel 2007 personal.xlsb file

[tvjt]

I understand in excel 2007 -- when you build a macro and save it to a personal workbook it saves the file in the xlstart menu and automatically opens behind the scenes when you open an Excel workbook---- My problem is when I build a macro and it asks if I want to save changes to the personal,xlsb file if I click on yes -- from than on, when I open Microsoft excel the standard blank sheet one does not open but the personal.xlsb which is supposed to open but behind the scene. Any suggestions... J.T.

 

[bomb #21]

I don't know 2007. But in previous versions you have to hide personal.xls, then close Excel (it'll probably prompt you to save), then re-run Excel & it should stay hidden.

HTH

 

[tvjt]

that did the trick ---thank you!