| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Close all without saving and exit without prompts
In article , Claus Busch
writes Hi Colin, Sub Test() Dim wbk As Workbook For Each wbk In Workbooks If wbk.Name < ThisWorkbook.Name Then wbk.Close savechanges:=False End If Next ThisWorkbook.Saved = True Application.Quit End Sub Regards Claus B. HI Guys OK thanks for this. All working fine now. Everything closes with no saving and no prompts at all. Perfect. ^_^ Best Wishes Colin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| close/open workbook without prompts | Excel Programming | |||
| Prompts to Discard digital signature while saving | Excel Programming | |||
| Saving Prompts | Excel Worksheet Functions | |||
| When saving CSV excel always prompts about the file format | Excel Discussion (Misc queries) | |||
| Saving a single Worksheet w/o redundant prompts | Excel Programming | |||
Threaded Mode
