RE: it's going to blow!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: K Dales (KDales_at_discussions.microsoft.com)
Date: 12/15/04 

Date: Wed, 15 Dec 2004 09:59:06 -0800

The macro itself would not be using processor time (except for a tiny bit of
overhead) so it must be the spell check itself that is processing so much.
How big is the worksheet? How much text?

For one thing, when you use Cells.CheckSpelling, you are specifying to check
every cell in the sheet. That is 256 x 32000 (roughly) and I don't know that
the spell checker is smart enough to skip blank cells. Can you do any better
at narrowing down the range of cells you are checking? It might help. At
the very least, try specifying ActiveSheet.UsedRange.CheckSpelling and see if
that improves the situation.

And if it does blow, send me a photo!

"el_peacock" wrote:

> Hi
> I have the following code attached to a control button in my xl97 worksheet:
>
> ActiveCell.Activate
> ActiveSheet.Unprotect Password:="mypassword"
> Cells.CheckSpelling
> ActiveSheet.Protect Password:="mypassword", DrawingObjects:=True, _
> Contents:=True, Scenarios:=True
>
> This allows staff to spellcheck on our protected documents after completing
> their part of the form. The problem is that when activated, the macro calls
> up the spellcheck facility, at which point my pc starts heating up and the
> fan starts whirring like never before. I'm running Windows XP Pro on a brand
> new Compaq P4 2.7Gig with stacks of RAM so I'm sure it's not a resource issue
> but I checked the task manager and the cpu usage rockets to 99%. I guess
> this is because whilst I'm clicking my way through the spell check, the macro
> is open and only finishes once the spellcheck is complete.
>
> Does anyone have any suggestions as to how to prevent this?!
> TIA
> ---------
> Gareth

Relevant Pages

  • protected document with spellcheck macro not working for others
    ... I seem to be having a problem with a macro I have created in Word 2003. ... The macro allows the user to run a spell check on a protected form ... saved the macro to normal.dot but when anyone else opens the form they ...
    (microsoft.public.word.vba.beginners)
  • Re: Spell Check Protected Form with Bookmarks
    ... and I created an icon on the toolbar to unprotect, spell check, and reprotect ... You might also name your starter macro ToolsProofing. ... This message is posted to a newsgroup. ... Bookmarks are not set to calculate on exit. ...
    (microsoft.public.word.spelling.grammar)
  • Re: Forms vs SpellCheck
    ... MVP site works. ... The macro still works. ... because the text fields get set back to not spell check and it does not ... the form to protect/unprotect? ...
    (microsoft.public.word.spelling.grammar)
  • Re: Spell Check Protected Form with Bookmarks
    ... Microsoft's Legal Users' Guide) http://addbalance.com/usersguide ... I'm by no means a Word or Macro expert so I don't know how to ... Bookmarks are not set to calculate on exit. ... because the text fields get set back to not spell check and it does not ...
    (microsoft.public.word.spelling.grammar)
  • Re: add spellcheck in a locked form
    ... If you want to spell check a form, then the user of the form must have ... normal.dot template, or the document itself, but if saved in the document ... there are macro security implications which could render it unavailable to ... "Jay Freedman" wrote: ...
    (microsoft.public.word.docmanagement)