On Apr 15, 9:16*am, Andrew wrote:
Hello,
For the past two years, I've been using a purchase order generator
which I made in Excel VBA. *The main file is a template with two
sheets. *Sheet 1 is the purchase order, and sheet 2 is a list of all
my contacts. *Sheet 1 has two buttons, one to update my contact list
and one to create a PO and save it to a specified folder... So, when I
hit the button to update the contacts, I get a dialog box which asks
for name, address, etc. *On that dialog box there is another button
which is supposed to update the contact list and then save the entire
file as the new template. *So, of course the new template will have
all of the VBA code. *This system worked well for 2 years is Excel
2003. *Last week I updated to Excel 2007 and when I updated my contact
page, the resulting template was saved but all of the VBA code was
gone. So, essentially the template is destroyed. *I tried this again
with another copy of the file and the same thing happened.

Can someone explain to me why Excel 2007 is erasing my VBA code? *And
what can I do to prevent this?

thanks

You can try saving it as an Excel Macro Enabled Template - .XLMT.
You should also check the settings under Excel Options Save - this
should be set at .XLSX.
We had the same problems changing over - basically you can loose the
VBA code when it saves from 2007 back to 2003 versions of excel