I got the solution.

The mistake that i was doing was-
While creating macros it gave option of saving. There i should have selected the proper template.
Quite silly of me..
Thanks a lot for your patience and help.