Disable all warnings with Application.DisplayAlerts = False

[KittyS]

Hello users!
I have some slicers connected to graphs in a spread sheet. When I clear a slicer filter I get the warning: "the maximum number of data series per chart is 255". I don't need to rearrange my charts because of this, I just want to disable this warning. I tried several things using Private Subs, such as these:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.DisplayAlerts = False
End Sub
Private Sub Worksheet_PivotTableAfterValueChange(ByVal TargetPivotTable As PivotTable, ByVal TargetRange As Range)
Application.DisplayAlerts = False
End Sub

not only in the worksheet, but also in the workbook. Yet the warning keeps coming. How can I get rid of it completely?

Thanks so much for helping me out!

Kitty

 

[James006]

Hello Kitty,

You could try to insert your instruction at the workbook level ... i.e. in the module ThisWorkbook ... :wink:

Private Sub Workbook_Open()
   Application.DisplayAlerts = False
End Sub

HTH

 

[KittyS]

Hi James,

I tried it, but unfortunately to no avail.... warning keeps coming.

Kitty

 

[James006]

Hi James,

I tried it, but unfortunately to no avail.... warning keeps coming.

Kitty

I should have added ... that once you have added this instruction ...
It will become available ... only after saving your workbook ... and closing it ...
Indeed, the instruction loads itself ... when you re-open the workbook ...

HTH

 

[KittyS]

Unfortunately... saving the workbook with this code and re-opening also do not suppress the warning...

Grtz,

Kitty

 

[James006]

Sorry this does not work ...

Alternative ... to be tested ...not ideal ... is to use SendKeys "~"

HTH