hi
Ctrl+F4 closes the active window...not the macro. this is my confusion. you
can close all the active window you want in the vb editor but when you call
the macro in code.....guess what runs. this is my confusion. what constitutes
a "closed" macro?
MVPs.....help!!!!!

Regards
FSt1

"Dana DeLouis" wrote:

what do you mean by "leave all the modules open" and "close all
modules"???

Hi. Select somewhere in a code module, and keep hitting Ctrl+F4 until
all the modules are closed.
I have collected a library of stuff in my Personal.xls file.
Since I don't often edit them, I try to remember to keep all of these
modules closed.
I have not read anything where this is a problem, but I would guess that
it might help a little, whatever that might mean.

I have a workbook with lots of code.

I have heard here in the newsgroups that code with about 64k of lines
will cause a crash. If you have a lot of lines of code, perhaps break
them up into more modules. (Just guessing here of course)

- - -
Dana DeLouis



FSt1 wrote:
hi
what do you mean by "leave all the modules open" and "close all modules"???
i do have some experence with vb and macros but this is terminology i
haven't heard before. please clairfy.

Regards
FSt1

"Don Wiss" wrote:

I have a workbook with lots of code. Usually I leave all of the modules
open. Sometimes the workbook blows up Excel. I will try closing all the
modules, but does it make a difference?

Don <www.donwiss.com (e-mail link at home page bottom).