aaawall91 wrote:for instance saving the Macro, I had to save it as a whole file, so like the file type was a 'Excel Macro-Enabled Workbook' which I think is fine but not sure.
I have not actually used the new version only the new VSTO. But of what I know that should be fine. VBA is no longer the primary code-behind in '07 and I believe it does that just to differentiate.
aaawall91 wrote:And I made the short-Cut key Z, however when I go to use it, it gives me the error "You must have exactly two areas to swap. You have 1 areas." I'm not sure what I did wrong.
The error is from the macro itself. You can actually see that text in the macro if you look above. Anyway, here it is in a nutshell: you need to select complete 'areas'. If you want to swap two rows you have to select the entire two rows. If you select three rows or partial rows you will get that error.