Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Let's try two thing:
1. a simple lie 2. a request not to be bothered Sub dural() ActiveWorkbook.Saved = True Application.DisplayAlerts = False ActiveWorkbook.Close End Sub -- Gary''s Student - gsnu200827 "dave glynn" wrote: I have a vba procedure that closes "n" number of files; each time it is about to delete the file it forces me to respond manually to confirm that I do want to close it. To an extent this defeats the purpose of programming in the first place. Likewise when I want to save the file at various stages similar confirmations are required. Is there any way to avoid these interventions? With thanks Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA Programming in Excel | Excel Programming | |||
Excel Programming | Excel Worksheet Functions | |||
Excel Programming | New Users to Excel | |||
VBA excel programming | Excel Programming | |||
Excel Programming | Excel Programming |