DisplayAlerts = False chooses the default response

[NeedForExcel]

Hi,

While using VBA, when there is a need to suppress alerts, I use Application.DisplayAlerts = False.

DisplayAlerts = False chooses the default response. What if I had to chose a different response. Is there a way to do it?

In the attached screenshot, the default is Update, however I wish to select Don't Update everytime this pops up.

Is there a way to do it?

P.S. - I know about Application.AskToUpdateLinks = False

I am just interested in knowing how to select a non default option.

[xlnitwit]

Hi,

You must either use the appropriate argument in the code that triggers the dialog- such as specifying not to update links when you open a workbook- or you must use CBT hooks and API function calls to find and send messages to the appropriate control. The former is obviously preferable when possible as there is unlikely to be a generic routine for the latter.

[NeedForExcel]

Hi xlnitwit,

Thank You for the reply..

The solutions shared by you are very new to me.

It would be generous of you if you could share some links or something that can send me in the right direction.

[TMS]

Look at: https://msdn.microsoft.com/en-us/lib...or=-2147217396

Use: UpdateLinks parameter to determine what option you want to take

[xlnitwit]

Here is a simple example of setting a hook- http://www.excely.com/excel-vba/chan...-buttons.shtml

In order to actually click a button, you would require the GetDlgItem API to get its window handle and then use SendMessage to send it a click event. That is not as straightforward as it may sound because you need to know in advance the correct ID to pass to GetDlgItem to get a handle to the correct button.

All in all, it is much easier to avoid the issue if at all possible.

[NeedForExcel]

Hi,

Thank you for the replies..

Sorry for my delayed response, I have not been able to access Excel Forum Lately.

Reps added

[TMS]

You're welcome. Thanks for the rep.