Loosing VBA project when opening up Excel 2007

[QuietMan]

This workbook has lost its VBA project, ActiveX controls and any other
programmability-related features.

I get this error whe I attempt to open up an excel 2003 file in excel 2007
does anyone know what could be causing this?

 

[Barb Reinhardt]

Is it possible you've saved the file as an .xlsx?

 

[QuietMan]

I open it up in 2007 and I get the error message...I can save as an xlsx file
but I still will not have access to the VBA project or any of the macros

 

[Barb Reinhardt]

Was the file saved in Excel 2003 or could it have been saved programmatically
in 2007 as a 2003 workbook?

 

[QuietMan]

Looks like the It guy who istalled excel 2007 disabled the VBA component
during instalation...

Is there a way I can activcate it without re-installing?

 

[Bogi]

Hi
Did you got answer to your question? I have same problem!

 

[Mike Middleton]

Bogi -

If VBA was not originally installed, you do not have to reinstall. Instead,
run the setup, and install (add) the VBA component.

- Mike

http://www.MikeMiddleton.com

 

[Bogi]

Thanks

Everything works now perfectly

Bogi -

If VBA was not originally installed, you do not have to reinstall. Instead,
run the setup, and install (add) the VBA component.

- Mike

http://www.MikeMiddleton.com