Disable link prompt from showing up

E

Edward

Hello,

I have a problem when Excel prompts the user to "Continue" or "Edit Links".
Is there a way to disable this prompt?

Here's what I've tried:
1. TOOLS - OPTIONS - EDIT - unchecked ASK TO UPDATE LINKS (Doesn't work, I
still get prompted to "continue" or "edit links" when I open a spreadsheet
with links.

2. I've used Personal.xls with the following macros:
' Begin Code to close Excel without save dialog
Sub Auto_Open()
For Each wb In Workbooks
wb.Saved = True
Next

For Each wb In Workbooks
wb.Saved = True
Next
' End Code to close Excel without save dialog

'turn off warnings
Application.DisplayAlerts = False
Application.AskToUpdateLinks = False
End Sub

' Begin Code to close Excel without save dialog
Sub Workbook_Open()
For Each wb In Workbooks
wb.Saved = True
Next

For Each wb In Workbooks
wb.Saved = True
Next
' End Code to close Excel without save dialog

'turn off warnings

Application.DisplayAlerts = False
Application.AskToUpdateLinks = False

End Sub


None of this code seems to do it either.

Anyone knows how to effectively disable these link prompts from showing up?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top