| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Hi Bernie,
Thank you very much. Have a good day! Robert -----Original Message----- Bony, You need to use a macro: Sub CloseWithoutAlert() Application.DisplayAlerts = False ActiveWorkbook.Close Application.DisplayAlerts = True End Sub HTH, Bernie MS Excel MVP "Bony Pony" wrote in message ... message when I haven't made any! I know I can open it read-only but I was wondering if there is a way to switch the alert off. I have tried application.displayalerts = false but that doesn't do it. Any ideas anyone? Thanks in advance! Bony Pony . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I unhide columns after clicking save? | Excel Worksheet Functions | |||
| save as html | Excel Discussion (Misc queries) | |||
| Excel 2002 crashing during "Save As" action. | Excel Discussion (Misc queries) | |||
| Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) | |||
| Missing "Save" and "Save As" functions | Excel Discussion (Misc queries) | |||
Hybrid Mode
