%P*Rr&^ wrote:
I added the final feature - the spell
checker! And the same thing happened. I guess somehow that's what the
problem is, either a bug in VBA or in the way I enacted the CheckSpelling
method.
Do you have a very large module?
I am wondering if you are pushing it over some size limit and that is what
is causing the loading of the workbook to fail.
If so, try splitting the module into 2 or more parts and see if you can
then add the CheckSpelling stuff OK.
You might also try using Rob Bovey's Code Cleaner
(from
http://www.BMSLtd.co.uk/mvp )
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup