why the macro is not included in the list?

[sumesh56]

i opened a worksheet named "get the top".clicked on vba.view code the
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 th
macro under the code group i don't see the macro which i include
recently.pls see that module number11 contains the
code.(workbook_open)see pic 3 named macrolist in personal. there ar
only 4 macros listed there.module no.11 is not there.see pic no.2.ther
are a lot many modules in which no.11 is also there. my question i
though in the module list, no.11 is present,why it is not coming when w
click on macro under the code group? when i see the personal workboo
only four macros are showing. where are others

+-------------------------------------------------------------------
|Filename: jpeg.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=963
+-------------------------------------------------------------------

 

[GS]

You can only see macros that aren't scoped *Private*, and do not take
arguments! Show the macro you want to run from the Macros dialog...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[GS]

Try...

In ThisWorkbook code window:

Option Explicit

Private Sub Workbook_Open()
Call SelectTopRow
End Sub


In a standard module:

Option Explicit

Sub SelectTopRow()
Rows(1).Select
End Sub

The above macro will now list in the Macros dialog!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[sumesh56]

I opened the worksheet. vba -click on the module and pasted yours. the
i clicked on the macros in the code group. now i can see the code nam
in the list. But on vba doble clicked on the worksheet. clicked vie
code. pasted yours. went to macros. i cannot see the your macro there
it is not listed there. kindly detail it . thanks.

this macro is not serving the purpose. I open a worksheet with so man
sheets. i select one and copy contents from it. goes to the second shee
paste it there. then comes to the first one. then i should get the shee
with the top row. that is what i want. means i should get a sheet or
file open with the top row displayed. no matter if it is opened afres
or is being selected from a batch of sheets.thank

+-------------------------------------------------------------------
+-------------------------------------------------------------------