Save sigh hanging forever

[dennisli]

Good afternoon,
I have a code written under 2003 Version. At the end of the code, I have a very simple code
[code}
Activebook.save
[/code]
It works very well under 2003 version. Now I switched this file to 2010 version. It works but the saving message box always shows on the window:
If I just click Save menu, got same results. Any ideas?
Thanks
Dennis

 

[Asala42]

Is the filename ending with the xlsm extension? That's needed for 2010 files with macros.

Not sure if this matters, but also tweak the code to:
AciveWorkbook.Save

 

[dennisli]

thank you, you are right.

 

[dennisli]

Sorry, I am back. Let me make my question clear.
I have changed the default format in my Excel 2010 to .xslm. After I make some changes on a .xlsm file, I want to save it. But I got a MsgBox to Save As in .xlsm. If I do not close the MsgBox, it will hang there forever. If I click it, it stops saving.
Appreciate.
Dennis