Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
DisplayAlerts = False not working for cell overwrite Joel Excel Programming 0 June 26th 09 02:17 PM
Application.DisplayAlerts = False - Not Working [email protected] Excel Programming 3 March 1st 06 08:39 PM
DisplayAlerts = false not working Mark Stephens Excel Programming 4 June 13th 05 06:05 AM
Can't Set DisplayAlerts to False Mark Driscol Excel Programming 1 April 6th 04 10:45 PM
Can't Set DisplayAlerts to False Mark Driscol Excel Programming 2 April 2nd 04 12:28 PM


All times are GMT +1. The time now is 06:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"