Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
selection
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 Joanne Jezebel wrote: 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" wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide a row in a table based upon a previous selection | Tables | |||
Word 2003 Selection or Range Objects | Microsoft Word Help | |||
Drop Down Selection on Save | Microsoft Word Help | |||
Problem with Advanced selection Criteria | Mailmerge | |||
When I print a word doc 'print selection' does not appear as an op | Microsoft Word Help |