selection

[Joanne]

I am using a macro to select all, then alt+9 to update fields in my
doc. It works just fine, but when finished, the doc is still
completely selected.
Could someone please tell me what command to use in my macro to get
rid of the selection highlighting before exiting the macro.
Much thanks
Joanne

 

[Jezebel]

Simpler is not to use the selection at all --

ActiveDocument.Fields.Update

will have the same effect. Either way, you're not updating fields in any
storyrange except the main body (ie not in headers or footers, textboxes,
footnotes, etc). If you need to update fields everywhere --

Dim pRange as Word.Range
For each pRange in ActiveDocument.StoryRanges
Do
pRange.Fields.Update
set pRange = pRange.NextStoryRange
Loop until pRange is nothing
Next

 

[Joanne]

Thanks Jezebel - solved the problem perfectly.

I do have one more question please.

On the lost focus event of this embedded spreadsheet, can I call the
update macro from the main word doc? I'm not even sure that lost focus
is allowed in Excel VBA or if there is some other command available
for when I exit the spreadsheet and return to the word doc. Can you
point me in the right direction please.
Thanks muchly