Application.AlertBeforeOverwriting = False

A

Aristotele64

Hi,
i want to set

Application.AlertBeforeOverwriting = False



for ONE FULL worksheet ......



ho do it ???



TIA
 
R

Ron de Bruin

If I understand you correct

Use this events in the Sheet module of the sheet

Private Sub Worksheet_Activate()
Application.AlertBeforeOverwriting = False
End Sub

Private Sub Worksheet_Deactivate()
Application.AlertBeforeOverwriting = True
End Sub
 
Top