Incorrect Function After Running Saving Macro

[SimonBailey]

Hi
I have a macro that saves an excel file as a file name related to a variable in a cell. After updating to Excel 2007 I have ammended the file to save as an xlsm file. The macro runs from a button on the Add-Ins ribbon. These buttons are created when the spread sheet is opened, and all other macros work fine with the buttons. However this one gives an "Incorrect funtion" with the ! in the yellow triangle, pop up error box after the macro has run, even though it has saved the file correctly, has anybody any idea why this is please?
By the way, if running via a button or through VBA editor it works fine.

Thanks
Simon

 

[SimonBailey]

 

[VoG]

This might be the issue http://www.rondebruin.nl/saveas.htm

 

[SimonBailey]

Thanks for your quick response. I had it set as a macro enabled book, but changed it to the fileformat:=52 shortcut in case this was the proble, but no joy. It seems strange that the problem only occures when running the macro via a button on the ribbon, not on a normal button or via the VB editor where all works fine.

Cheers
Simon