Thread: Application.AlertBeforeOverwriting = False
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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









Reply With QuoteReply With Quote