View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Bill Manville Bill Manville is offline
external usenet poster
 
Posts: 473
Default Excel XP Macro Loading Problem

%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