Excel Macros don't save new edits.

[dgarris]

I created a spreadsheet with a module that contains a VB macro. Saved it and then loaded it. All worked fine. Then I needed to update the macro. Saved it. Opened the spreadsheet and the old, un-edited macro appears. The new macro changes are lost. Why can't I save the new edits to my macro? Using Excel 2010.

 

[Andrew Poulsom]

Welcome to MrExcel.

Are you sure that you didn't Save As something else rather than just Save?

 

[dgarris]

I'm sure. I've even save the new macro edits w/spreadsheet under a different name and it saves the sheet with the old unedited macro.