close excel application.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Is there any way I can control the dialog box which prompts to save the
changes of the workbook? Basically I dont want to display the dialog box when
they user clicks on cross.

Thanks
 
Application.DisplayAlerts = False

.....

Application.DisplayAlerts = True
 
HI VJ

This what I use hope it helps

Application.AlertBeforeOverwriting = False
ThisWorkbook.Close savechanges:=False

This closes the work book with no prompt and does not save changes.

You could easily ammend the code to save with no alerts and close.

Best N10
 
..alertbeforeoverwriting refers to the warning you get when you drag cells over
non-empty cells.

Not overwriting the another file.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Preventing "save changes" dialog box??? 3
Saving a Workbook cause's Error's 7
Closing application problem 2
How can just opening & closing a workbook prompt the Save? dialog? 4
Auto close the prompt & dialog boxes 2
Saving Workbook 1
Excel Providing user message when RED X clicked & properly closing application. 2
deactivate save changes 1

Back
Top