vba Cancel Save As

  • Thread starter Thread starter JAO
  • Start date Start date
J

JAO

I have written a macro that shows the Save As dialogue box, but I'd like to
add code that closes a workbook if the user selects "cancel".

Can anyone help?
 
When using the GetSaveAsFilename method, the method returns FALSE if the user
clicks Cancel. Thus, you only need to check the result of the method.

Dim response
response = Application.GetSaveAsFilename

if not response then
' User clicked false
Workbooks(NumberOrNameHere).close
else
' Do stuff
End if

HTH,
Matthew Pfluger
 

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
Saving a workbook using VBA 5
Close w/o saving changes 6
Infinite loop cancelling BeforeSave 10
Maintaining Macros on a sheet when it is saved as a new workbook 2
Copy from Excel to Word 2
Auto save question 2
Disable save/saveas dialog box upon closing 11

Back
Top