Display alert ignored

[webdevptg]

Hi,

I have a procedure created that will update an excel table in a different book, everything is working perfectly, but I wanted no message to be presented to users.
I am using the display alert = false, but there are still 2 messages I wanted to avoid (message attach post), the one to delete lines and the one to paste values.

....

Application.ScreenUpdating = False

Application.DisplayAlerts = False

if numberRecord > 0 Then
             wbTarget.Worksheets("DataBase").ListObjects("GlobalData").Range.AutoFilter Field:=2, Criteria1:=strCriteria

            wbTarget.Worksheets("DataBase").ListObjects("GlobalData").DataBodyRange.SpecialCells(xlCellTypeVisible).Delete
End If


wsSource.Range("A5:P44").SpecialCells(xlCellTypeVisible).Copy


wbTarget.Worksheets("DataBase").Range("C" & lastRow).PasteSpecial Paste:=xlPasteValues


Application.DisplayAlerts = True
Application.ScreenUpdating = True

 

[Michael M]

Insert the extra text into this line

wbTarget.Worksheets("DataBase").ListObjects("GlobalData").DataBodyRange.SpecialCells(xlCellTypeVisible).EntireRow.Delete

AND
HAve you ticked the box "Do not show this again" ?

 

[webdevptg]

Insert the extra text into this line

wbTarget.Worksheets("DataBase").ListObjects("GlobalData").DataBodyRange.SpecialCells(xlCellTypeVisible).EntireRow.Delete

AND
HAve you ticked the box "Do not show this again" ?

H,

msg delete
With the line above shows the error 1004: "This won't work because it would move cells in a table on your worksheet" (attach msg error)

msg paste
Regarding the information message of the paste values line, the user can always activate the option "Do not show this again", but I would like it to never appear

 

[webdevptg]

I found the solution

wbTarget.DisplayAlerts = False

....

wbTarget.DisplayAlerts = True

 

[smozgur]

I found the solution

I certainly don't think so. You should have fixed something else somewhere else in your code. DisplayAlerts is not a workbook object property but an Application property. Your code must fail on that line, unless you are ignoring the errors in your code.