VBA code gets lost from workbook if I paste in new data and save???

L

Lonnie

Any ideas that you may have to help me prevent this is greatly
appreciated.I have written an application in excel 97 running on
Windows 2000. The application takes data from a sheet that I manually
paste the data into and then creates a batch of files based on that
data. I can open, close, save, and 'save as' as often as I like, until
I paste in new data and save/'save as'. Once I open it, after having
pasted new data, there is no longer any VBA code, the buttons are
still there, but there is no property information--nor am I prompted
to enable macros when I open it???


Thank you in advance--Lonnie
 
T

Tom Ogilvy

Check what format you are saving the workbook in. In Tools=>Options,
Transition Tab, the first dropdown should say

Microsoft Excel Workbook rather than something like

Microsoft Excel 5.0/95 Workbook or anything else.
 
Top