Excel Macros in 2007

  • Thread starter Thread starter alistew
  • Start date Start date
A

alistew

I am using Office 2007, and every time I open an Excel file created in the
2003 format it removes the macros and code I have created in that file.

Is there a way i can get round this?
 
make sure you instaled visual basic in excel 2007. it not installed
automatic. see if alt-f11 open the vbe. if no redo office setup and look
for visual bacic in shared features.

|I am using Office 2007, and every time I open an Excel file created in the
| 2003 format it removes the macros and code I have created in that file.
|
| Is there a way i can get round this?
 
If you save the file in default xlsx format, it strips out the VBA parts of
the file before saving. You need to save it as 'macro enabled', or xlsm
format.

- Jon
 
Back
Top