I have a .frx of just over 100 K, so that shouldn't be the problem.
Your best bet is the Code Cleaner and my guess is that that will solve
it.

RBS

wrote:
RB Smissaert wrote:
3 things to think of:
1. Does it have Option Explicit at the top of every module, class module
and form module and with that does it compile?
2. Best to keep the size of any module (when exported) below 64 Kb.
3. Run the free VBA code cleaner:
http://www.appspro.com/Utilities/CodeCleaner.htm

Your file size shouldn't be a problem at all. I have an .xla that is over 5
Mb
and works perfectly fine.

RBS

Thanks...
1. All codes with option explicit from very beginning
2. All modules are smaller than 10K... The form is big (22K codes in
.frm file, but the .frx file is 96K... I don't know if here is the
problem)
3. Code Cleaner need an admin account to install... Trying to get on
now...

I don't think size matters either... I once got an Excel program of
19M...
Today I found if I save the file before running macro, it works
perfectly. so adding ActiveWorkbook.Save is a naive solution...
But I still want to know why Excel behaves like this...(Maybe it is a
compiling error and Excel compiles codes when file saved?) Any hints?