"Not responding" ... do you sometimes see this message at the top of a Word window when it’s running a long macro? If so, you don’t need to panic.
When a macro is running, if it’s taking rather a long time (according to Microsoft), Word displays a warning message in the title bar of the window – "Not responding" – and the screen display freezes. Actually, the macro hasn’t stopped working; it’s just that the macro is using up so much processing time that the computer’s operating system decides it hasn’t got time to update the screen display – well, not until the macro finishes.
The user’s natural response at this point is to click on the screen – just to check if Word is still working. Definitely don’t do that! By clicking on the screen you’re trying to force Word to update the screen display, and that takes up even more processor time. This can then cause Word to crash altogether. [You did save that file before running the macro, didn’t you?!]
So what should you do? Be patient. Make a cup of tea. Take the dog for a walk.
Good news ...
But there’s some good news, especially for users of my macros. I’ve discovered a new (to me) command (DoEvents) that I can put in my programs; it makes the macro stop for a fraction of a second and this allows the computer to update the screen.
I won’t say that “Not responding" will be a thing of the past, but if you use the latest (8 November or later) versions of my macros you’ll still be able to see onscreen that something is still going on. More importantly, you will be able to see the prompts that the macro puts on the status bar down at the bottom of the window to show its progress.
A final tip ...
One final bit of advice still remains. For running macros that use lots of computer time, do try the macro out first with a more modest-sized document – a few thousand words – and not on your magnum opus 150,000-word book.
Get the improved versions ...
Improved versions of FRedit, HyphenAlyse, DocAlyse, ProperNounAlyse, SpellingToolkit, WordPairAlyse, etc. are available by downloading my free macro book here:
Paul Beverley has over 25 years’ experience as a technical author, publisher, proofreader and editor, and has the highest available editing qualification: LCGI (editing skills). Paul is passionate about macros and has used his programming ability to complement his writing and editing skills. Through his series of Macro Chat posts, he aims to share his knowledge and open up a dialogue about the benefits of macros to anyone working with words. Comments and questions are always welcome so please do join the discussion. No question is too basic!
Visit his business website at Archive Publications, and access his free book at Macros for Writers and Editors.
11/11/2015 09:31:16 am
Thanks, Paul, for the explanation. I know that when I run my Journals macro in my EditTools program, I get that message, but I also know why -- the dataset that the macro has to compare against has nearly 100,000 entries. Combine that with a reference list that needs checking that runs 450 or more references, bound to have a delay.
11/11/2015 10:03:50 am
In the past, I've been guilty of the impatience you describe, Paul. I'd see that "Not responding" message and start hitting the return key repeatedly in an effort to make Word "work" again. Or I'd toggle to a different program so that I could do something productive while I was waiting for Word to get its act together. Over time, I realized that it still had its act together and I learned to leave it alone and use the time as an opportunity to take a short break. This is post is a good reminder to just be patient!
13/11/2015 09:12:04 am
I echo Louise's words and thank you yet again, Paul.
Leave a Reply.
If you'd like me to email you when a new blog post is available, sign up for blog alerts!
'Louise uses her expertise to hone a story until it's razor sharp, while still allowing the author’s voice to remain dominant.'
'I wholeheartedly recommend her services ... Just don’t hire her when I need her.'
J B Turner
'Sincere thanks for a beautiful and elegant piece of work. First class.'
'What makes her stand out and shine is her ability to immerse herself in your story.'
'A million thanks – your mark-up is perfect, as always.'