View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
myoung myoung is offline
external usenet poster
 
Posts: 1
Default DisplayAlerts property is not changing to False


Hello All:

My excel application neglects to chenge the propert
Application.DisplayAlerts to false.
Here is the code:

Application.DisplayAlerts = False
Application.Quit

When I step through the code and check the displayalerts property it i
set to true.

I have been reading other entries and can not seem to find a definit
problem/resolution (not to mention no particular help from Microsoft).

I have tried the
"workbooks(name.xls).close SaveChanges:=False"
(changes are not to be saved) method but this throws an exception whe
I try to quit.

Any thoughts?

Thanks,

Mik

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com