Well thanks for your patient replies..But I am still not through with my problem..
I followed the procedure, I created new template. then opened a new file using that new template, and then created macros. In the VBE it shows first normal template, below it the template i created and then the current file. the macro was still created in the module under the normal template. Finally i copied the macro in a new module created in my file. Its fine for the time being, proceeding with this....