Updating link message issue

[ABabeNChrist]

Hi
I’m using a Microsoft Office 2007 Word Macro-Enabled Document, that has varies UserForms. A problem I seem to be having is when I open document I use.

Code: Select all

Private Sub Document_Open()
Call UpdateAllFields
Call UpdateAllFields
UserForm1.Show
End Sub

To go straight to UserForm1, but I seem to get this message first that refers to links. Is there another way around this?

linked message.JPG

[HansV]

Does it help if you insert a line

Application.DisplayAlerts = False

at the beginning of the macro, and

Application.DisplayAlerts = True

at the end?

[ABabeNChrist]

Hi HansV
I tried what you mentioned with no success
I’m using a docm that I use as a main doc. With this main docm I use UserForm’s to navigate to other docm’s, use to enter new data using bookmarks on main docm, print and save reports. The main docm stores the new updated data, so that when I open a report from a UserForm, it then refreshes link. I’m thinking probably as the bookmarks refresh at opening that is why I am receiving this message, I’m really sure. Do you think I should eliminate the UserForm to enter data on and just enter directly on docm.

[HansV]

I don't have Word 2007, but I don't think the userform is the cause of the problem.