Have been playing around with VBA coding these days (with Excel 2010) as we are building a Budget Template to capture Budgets for various projects and then consolidate it into one excel workbook so that it can be imported into AX.
VB and VBA has been one of my favorite languages since I started programming back in 2000. I still love to work in VB editor if i get a chance and one of my first project was building a Review Toolbar using VBA (Word Macros), Very interesting then :)
Now after 10 years, there has been quite some changes with the way macros are handled especially with Excel based macros. In Excel 2010, if you want to save a sheet/workbook then while saving you have to use the "Excel Macro Enabled Worksheet" rather than the default Excel option.
Below Link helped me To save macros http://www.dummies.com/how-to/content/saving-and-using-an-excel-2010-macroenabled-workbo.html