Thread: module location
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default module location

hi again,
forgot to mention,
to see modules, open the vb editor (alt+F11). on the left
click the + next to your project(file name). this should
display all the modules in your file.

-----Original Message-----
hi,
if the macro excutes then it is stored in your 1st file

or
at least enough code to open the 2nd file to call the
macro.
if it opens another file, then the macro has code in it

to
open the 2nd file.
Post your code.

-----Original Message-----
When I execute one of my macros, it starts another excel
file before executing the macro. I think that vba has

it
stored in the second excel file.

Can anyone tell me how to check this; and how to get the
macro located only in the first excel file so the macro
does not start another excel file in order to do its

work?

.

.