Help With Error Message Please? -- "Remote Links Will Be Terminat

D

dimm

Hi, :-(

I get the following error message when I open a workbook. Can someone please
explain what it means, what clicking on 'Ok' or 'Cancel' does, and most
importantly perhaps....if there is some code I can put into my auto-open
macro to get rid of it?

remotelinkszu9.jpg


thkoutsidthebox

Thankyou.
 
D

dimm

Hi FSt1

The error message appears when I open my workbook.
It says:

"Remote Links Will Be Terminated"

I can click on either "Ok" or "Cancel". Neither button seems to do anything
apart from close the error message!

This workbooks has an auto open macro, but nothing that I think would cause
this. I don't know where the remote links are in this workbook....is there a
way to put the 'UpdateLinks:=3' command into an auto_open macro?

Thanks
 
F

FSt1

hi
untested but try this dave peterson suggestion
With Application
..DisplayAlerts = False
..IgnoreRemoteRequests = True
..DisplayAlerts = True
End With

regards
FSt1
 
D

dimm

Hey it worked! Thanks. :-D

I only put in the first parts with the 'Display Alerts = False' and
'IgnoreRR=True'

Thanks again.

L8rs.
 
F

FSt1

hi
i would turn alerts back on. it is not wise to turn them off and not turn
them back on again. one turns them off when one knows the code will produce
an annoying little message that doesn't need to display while code is
running. but do turn them back on again before end sub.

Regards
FSt1
 
Top