Macro to go into options??

[Submersed]

Can you make a macro that goes to
Tools>options>edit (tab) then untick the box ask to update automatic links

Is that possible?

If so ... I also need it to come up before the message asking about the links when the document first opens?

Am I able to turn the display alerts off and then straight back on after it has done that message?

Many Thanks

 

[jim may]

Part 1 of your question:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 7/24/2007 by Jim May
'

'
Application.AskToUpdateLinks = False
End Sub

 

[ADAMC]

Hi .....

Application.AskToUpdateLinks = False
Will untick the update automatic links box.

Application.DisplayAlerts = False will get rid of message about do you wish to update links, place in a workbook open event

 

[ADAMC]

Hi Submersed

When you open a workbook...Do you want to
Turn off displayalerts
turn off update links..
then turn displayalerts back on?

 

[Submersed]

Hi,

Thanks for the replies!

Yea..I would like for that links box, (the one that appears after enable macros) to be hidden! thats the only alert i need hiding!

So yea..pretty much what u said

Thanks