i opened a worksheet named "get the top".clicked on vba.view code then pasted a code.it is module No.11.minimised it.went to the excel file. when i tried to run the macro..it doesn't work. when i clicked on the macro under the code group i don't see the macro which i included recently.pls see that module number11 contains the code.(workbook_open)see pic 3 named macrolist in personal. there are only 4 macros listed there.module no.11 is not there.see pic no.2.there are a lot many modules in which no.11 is also there. my question is though in the module list, no.11 is present,why it is not coming when we click on macro under the code group? when i see the personal workbook only four macros are showing. where are others?