code lost after saving

[Glen]

I wrote VBA code to process data in an Excel 97
spreadsheet. I saved it a few times during the coding.
However, when I reopened it later, I can't find the code I
saved in "View Code." All data that was generated is
still there.

I have written many excel vba codes. This is the first
time it has happened to me. Are there have any ideas to
help resolve this problem?

 

[Rick]

Have you double clicked all the worksheets and the
workbook and the modules in the VBE (when you push Alt-
F11)? Is the code not anywhere in these areas?

 

[pfsardella]

I've experienced this problem when I thought that I was saving the
code in one workbook, when I was actually saving in another workbook
that was open at the same time.

HTH
Paul