code lost after saving
 

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?

code lost after saving
 

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?

-----Original Message-----
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?




.

code lost after saving
 

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
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

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?