Macro to chose an option in a message box, like update, without just skipping it

[becca0903]

I need a macro to select an option in a message box that pops up when the file opens, that says update. Right now you have to manually click the update option before the macro will continue. I've seen where everyone uses the Application.DisplayAlerts=True and Application.DisplayAlerts=False, but I think that just skips the message box, right? I need the option to be selected so the file will update.

[walruseggman]

Why not eliminate the messagebox and just run whatever code runs when you hit the update button?

[dominicb]

Good afternoon becca0903

Are you referring to the box that asks if you want to update links?

If so, go to Data > Edit Links, Startup Prompt and select the appropriate option – it’s probably the third one down you want – and click OK.

If it’s not this box you’re referring to, we’ll need more info.

HTH

DominicB

[becca0903]

When you click the refresh macro and it opens the next file, that file automatically pulls up a message box that says update or cancel and I need it to click update before saving and closing.

[dominicb]

Hi becca0903

You know that there are no macros in the workbook that you've uploaded don't you?

DominicB

[becca0903]

This one should have it. Sorry about that.

[dominicb]

This one should have it. Sorry about that.

'fraid not.

DominicB