Disable prompt

[Noz2k]

I currently have a macro set up which before performing any calculations first updates the information with data from another workbook. However when it does this is brings up a prompt which asks for confirmation that you want to update.

Is it possible so disable this prompt and just automatically update?

I know I can change my options so that the prompt is not shown on my computer, however I am not designing it for myself, and I don't wish to disable the prompt for all workbooks, just in this instance.

 

[VoG]

Try this

Application.DisplayAlerts = False
'
'code that generates a message
'
Application.DisplayAlerts = True

 

[Noz2k]

Thank VoG, I already have that in my code and it doesn't seem to be making a difference?

Application.DisplayAlerts = False
Application.Workbooks.Open ("\\Filelocation/xlsx")
Workbooks("Log10").Sheets("Data").Name = "Sheet50"
Workbooks("LogData").Sheets("Data").Copy Before:=Workbooks("Log10").Sheets("Sheet50")
Workbooks("Log10").Sheets("Sheet50").Activate
Sheets("sheet50").Visible = xlSheetVisible
Sheets("Sheet50").Delete
Workbooks("LogData").Close
Application.DisplayAlerts = True

Have tried entering the line Application.DisplayAlerts = False in the immediate window but it still has no affect and the prompt is shown

 

[Noz2k]

So I added the line

Application.AskToUpdateLinks = False

and this seems to have eliminated the prompt

 

[VoG]

Excellent. Thanks for the feedback.