AutoSave

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

Guest

i have a program which automatically saves a spreadsheet to the server in the
correct file (ie. estimate\Quotes\EST18000\EST18500\....)

if the name already exists, the Excel VBA poses the msgbox if i would like
to save over it or not. if the user clicks 'yes', the program is fine and
saves over the existing, but if the user clicks 'no' or 'cancel', the program
crashes. i'd like it if a 'no' or 'cancel' selection simply tells the program
to EXIT rather then get a 'END" or 'DEBUG' msgbox.

what is the command to do so?
 
try
application.displayalerts=false
code
application.displayalerts=true
 
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

Excel Providing user message when RED X clicked & properly closing application. 2
combobox after change but user hits cancel to message box 5
userform program keeps crashing 4
VBA code for Msgbox 5
Excell 2021 0
Force input in multiple cells in Excel form 8
Excel Is it possible to ask a question within a question? 0
Code to Implement Required Cells Not Working 3

Back
Top