If you are using the excel 2007 version while saving you have to save
it as macro enabled sheet.

If the macro is recorded in Workbook-1 and if you close the workbook-1
you cannot run the macro because the code was there in workbook-1.

Regards

Heera