why the macro is not included in the list?

S

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
+-------------------------------------------------------------------
 
G

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
 
G

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
 
S

sumesh56

sumesh56;1616860 said:
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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top