Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DisplayAlerts property is not changing to False
Mike,
You may want to try using the saved property of the Workbook Object. For example: ThisWorkbook.Saved = True Application.Quit If you have more than one workbook open and you want all of them closed without saving any of them, try: Dim wkBooks Dim wkBook Set wkBooks = Application.Workbooks For Each wkBook In wkBooks wkBook.Saved = True wkBook.Close Next wkBook Application.Quit Hopefully that helps. Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manually changing a picture (shape) name property | Excel Discussion (Misc queries) | |||
changing an activex control property using a macro | Excel Discussion (Misc queries) | |||
changing property of a picture that is already pasted on excel | New Users to Excel | |||
DisplayAlerts and ScreenUpdate will not set to False | New Users to Excel | |||
EnableEvents and DisplayAlerts problems | Excel Programming |