Thread: DisplayAlerts = False not working for cell overwrite
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
iperlovsky iperlovsky is offline
external usenet poster
  
Posts: 50
Default DisplayAlerts = False not working for cell overwrite

I have the following code for which I continue to receive a cell overwrite
prompt despite my insertion of Application.DisplayAlerts = False. Any
suggestions?

Sub Histo()

Application.DisplayAlerts = False

Application.Run "ATPVBAEN.XLA!Histogram", ActiveSheet.Range("_01"),
ActiveSheet.Range("$FV$34"), _ , False, False, False, False

Application.DisplayAlerts = True

End Sub

Reply With QuoteReply With Quote