Application.AlertBeforeOverwriting = False
 

Hi,
i want to set

Application.AlertBeforeOverwriting = False



for ONE FULL worksheet ......



ho do it ???



TIA

Application.AlertBeforeOverwriting = False
 

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Aristotele64" wrote in message ...

Hi,
i want to set

Application.AlertBeforeOverwriting = False



for ONE FULL worksheet ......



ho do it ???



TIA