I am a supporter of St. Joseph's hospice. If you find this site useful or if it helped you, consider a small donation to St. Joseph's, please.

Information on
St. Joseph's

 

If you run Excel 2007 © and you receive the VBA error message "No RETURN() or HALT() function found on macro sheet", then simply switch off AutoRecovery:

Save your file first.

Klick top left application button,
then select Excel Options in the bottom line of the pop-up window,
go to Save and untick the Save Auto Recover information button

If Excel crashes, do not worry. Cancel any recovery attempt. Open the file again and try to switch off AutoRecovery again.

Now test your macros and finally switch on AutoRecovery again.

Worked for me...