Macro Code Not Saving

[Chris Moffatt]

Hi, I have 8 workbooks one of which will not save the macro generated code, except for the REM and Sub statements. This may have come about after reverting to an auto generated save, but I cannot get the work done. I have checked the options, saved and exited, etc but this workbook just won't work. Any suggestions?

 

[GTO]

Hi, I have 8 workbooks one of which will not save the macro generated code, except for the REM and Sub statements. This may have come about after reverting to an auto generated save, but I cannot get the work done. I have checked the options, saved and exited, etc but this workbook just won't work. Any suggestions?

Are you saying that you have eight workbooks which have their VBProject being programmatically updated (presumably from another workbook?) and that only one of these 8 workbooks fails to save the updates to its code?

Mark