Macro

You can enable macros in Excel by setting your Excel Security Level:

• Office 2000-2003:
  Menu :: Tools :: Macros :: Security.
• Office 2007:
  Microsoft Office Button :: Excel Options :: Trust Center :: Center Settings :: Macro Settings.

You can set Security to High, Medium or Low:

• High Security.
  All Excel macros (except from trusted sources) are disabled.
• Medium Security.
  User is prompted on each file-open to enable or disable Excel Macros
• Low Security.
  Excel Macros can run automatically without a prompt. You are not protected from potentially unsafe macros

Thanks for Sharing

If anyone needs macro to be written please contact me.