What Code Cleaner does is Export the components (modules and userforms),
removes them, saves the file, then reimports the components. As far as I
know, it ignores the code behind sheets and workbooks.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Susan" wrote in message
oups.com...
i have a question, tho..........
if you don't use a commercial code cleaner, how do you clean userforms
& worksheet codes????
well, worksheet codes i can see you could copy & paste everything into
a new sheet, including the data. but userforms?
:)
susan


On May 11, 8:57 am, Susan wrote:
my thanks to all of you for explaining this, also! i've always
wondered about this, especially since (when i'm done) my code is also
tidy & neat..... i didn't realize there was behind-the-scenes stuff
going on.
but i think i'd feel more comfortable with the copying to notepad,
delete module, insert new & recopy code.

might also explain why some of my very complicated & hard to write (to
me) codes run so slowly - finished code is not that long but there
were LOTS of rewrites.
:)
susan

On May 11, 5:32 am, wrote:



Many thanks for your replies. Makes it much more clear to me. Still
though it's a bit strange phenomenon to me: I have understanding for
the phenomenon (my code isn't 100% bug-free neither), but then a third
party piece of software (or yourself) has to take care of this... ?

I just used VBA Cleaner for the first time after a month working full
time on a project. For as far I know I hadn't any problems compiling.
(It was just bad luck for me, because cleaning didn't solve my spooky
problem with the ControlSources. But that's maybe another thread worth
it..)
I make sure to clean the files before delivery. Thanks again.

Bart- Hide quoted text -

- Show quoted text -