Hi
I have scoured the net for hours on this with no luck so hoping someone can assist. I have a 3 page word document locked to form field entry. When a user chooses a certain option it:
1. Sets Application.ScreenUpdating = False
2. Unlocks the form
3. Moves to various bookmark positions and populates 4 tables with various information. 1 table is above the original form field and the other 3 are below but the formfield is not pushed off the page by upper table growing in size.
4. Locks the form
5. Sets Application.ScreenUpdating = True
6. Uses ActiveDocument.Bookmarks("Text1").Range.Fields(1).Result.Select to return to the original formfield.
My problem is that the window position jumps a few inches when the focus moves back to the original form field, there are several other form fields where this will happen which wont make the user experience any good. I think it is because a table above it has grown. What i would like to do is lock the page position so it cannot be scrolled up or down during the background work.
I would be really grateful if someone could point me to a solution for this?
Many thanks
Paul
I have scoured the net for hours on this with no luck so hoping someone can assist. I have a 3 page word document locked to form field entry. When a user chooses a certain option it:
1. Sets Application.ScreenUpdating = False
2. Unlocks the form
3. Moves to various bookmark positions and populates 4 tables with various information. 1 table is above the original form field and the other 3 are below but the formfield is not pushed off the page by upper table growing in size.
4. Locks the form
5. Sets Application.ScreenUpdating = True
6. Uses ActiveDocument.Bookmarks("Text1").Range.Fields(1).Result.Select to return to the original formfield.
My problem is that the window position jumps a few inches when the focus moves back to the original form field, there are several other form fields where this will happen which wont make the user experience any good. I think it is because a table above it has grown. What i would like to do is lock the page position so it cannot be scrolled up or down during the background work.
I would be really grateful if someone could point me to a solution for this?
Many thanks
Paul
