| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SAVE AS MACRO
I have a "Save As" macro. When activated a box appears asking for a file name.
If the the file name already exists a prompt asks if the existing file should be over - written. If I answer YES there is no problem. If I answer NO a VBS prompt asks if I want to END or DEBUG. Ideally if the answer is NO I would want to return to the sheet the macro was in. Mike. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Insert Current Date into cell - Macro to "Save As" | Excel Worksheet Functions | |||
| Macro to Save without the Save Message | Excel Discussion (Misc queries) | |||
| Save As macro | Excel Programming | |||
| ASP: Open Excel File with Macro, Allow Macro to run, and then save | Excel Programming | |||
| Prompted to save changes after macro save - why? | Excel Programming | |||
Threaded Mode
