Problem saving macro Excel 2007/2010

Hi everyone,
I created the following macro according to Excel 2007:

Please Login or Register  to view this content.

Then I used Excel 2010, I saved it but I got the following pop up window:

"The following features cannot be saved in macro-free workbooks:"
VB project
to save a file with these features, click No, and then choose a macro-enabled file type in the File Type list.

To continue saving as a macro-free workbook, click Yes"

If I click Yes it will be saved.
The problem is that when I open up the file again, it does not contain any macro.

If I click No I get the pop up window that appears when you click on "Save as". So I try to save as Excel97-2003 but I got error messages saying that in some spreadsheets the data exceed the column limit (if I remember correctly it is 256).

I guess it is a problem related to the version of excel/File format.
I am using excel 2010.


Any thoughts about that?


I believe I have to add a line in the code.

Thank you very much.

Save it as a macro-enabled workbook (the second option in the File Type dropdown).