| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If user says "No" to FileSaveAs Overwrite?
My macro asks the user for a FileSaveAsName, then tries to save the file with:
ActiveWorkbook.SaveAs Filename:=sFileSaveName, ... How can I tell if the user gets the "File exists, Overwrite?" prompt, and answers "no"? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 displays Locked by "another user", does not show User I | Excel Discussion (Misc queries) | |||
| How do I suppress the "Do you want to overwrite the destination cells" message | Setting up and Configuration of Excel | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| How do you turn off "Save a copy/Overwrite changes" dialog box | Excel Discussion (Misc queries) | |||
| Find a workbook and "overwrite it with the latest Excel format" | Excel Programming | |||
Threaded Mode
