Why wont it let me save Macro even though it is enabled

[tomkelly88]

Hi

I am using Excel 2007, I have enabled Macro using Excel Options -> Trust Centre Setting etc...But yet when i go to save my file it says that "the following cannot be saved in macro-free workbooks: VB Project To save a file with these features, Click No and the choose a macro-enabled file type the File Type List. To continue saving as a macro free file click Yes"

I know have enabled the workbook to allow for me to use macro...

Why wont it let me save it?

Anyone thanks

 

[VoG]

Click the Office button (top left) and click Excel Options.

Click on Save then select Macro enabled workbook (.xlsm) from the dropdown and click OK.

 

[tomkelly88]

thanks