| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cancel Button on file save
Using this code
NewName = InputBox(prompt:="File Name and Directory", Default:=FName) ActiveWorkbook.SaveAs Filename:=NewName, _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False, AddToMru:=True When the user presses the cancel key the macro fails. What do I add to get it to just end the sub. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File Save, yes, no, cancel macro | Excel Programming | |||
| Capturing Cancel button on save file dialogue | Excel Programming | |||
| How to CANCEL file SAVE PROMPT when MACRO is running? | Excel Discussion (Misc queries) | |||
| Cancel Button in Open File Window | Excel Programming | |||
| How check for No/Cancel Button when SaveAs and file already exists? | Excel Programming | |||
Threaded Mode
