When I attempt to create new macros at least in between sessions in working
on my spreadsheets, it appears that the
VB Editor puts the code into new
basic modules. I have modules 1 through 4 right now, but I don't seem to be
able to see them all simultaneously and there are functions I developed in
one module that I really want to use in another module. I can see them in
the object browser, but I can't seem to combine them..... I don't want to
have them all in the same physical file if I can help it.
Also I am trying to locate the actual physical file in which they are
stored. They don't seem to be stored as a .BAS file.
Can someone explain how they are being stored and what I need to do to
reference one module function inside of another module?
--
Henry Stock, Network Administrator
onProject.com
3 Wing Drive
Cedar Knolls, NJ 07927-1006