CODEWITHSUNDEEP
vbaexcel-2010
Chrislaar123
Chrislaar123

Reputation: 321

Application.DisplayAlerts = True doesn't work in vba excel code

I have a function that brings up the generic warning when merging two fields together. I want to suppress this message using vba. However after looking on the forums, I found that "Application.DisplayAlerts = True" should do the trick. However when I try to apply the code there is no option for Application. then display alerts. Do i have to import a specific library reference for this? I currently have Excel 14.0 imported..

Upvotes: 2

Views: 18592

Answers (1)

Chrislaar123
Chrislaar123

Reputation: 321

I found the resolution myself.

Because Application.DisplayAlerts = False was to set the access program that was calling on my create excel object to ignore any alerts displayed by access. So to solve it I simply wrote objExcel.DisplayAlerts = false

Upvotes: 3

Related Questions