Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message box and Save as Macro
Hi,
I am currently working on a macro that performs a few tasks. The end result is emailing the document out to another user. What I want part of the macro to do is the following: 1. Message box: Did you save as current version? If Yes - then finish the current macro by emailing it out If No - Save As function and then when the user saves it in their own designated folder, then complete the macro that is already there emailing it out. Does that make sense? This is my current macro: |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message box and Save as Macro
No current macro attached. Question though: why ask the user a question?
Why not do the check programmatically? Chances are ... you know how the saying goes, "You can lead a horse to water... odd are it'll drown." <vbg -- Zack Barresse "Danielle0904" wrote in message ... Hi, I am currently working on a macro that performs a few tasks. The end result is emailing the document out to another user. What I want part of the macro to do is the following: 1. Message box: Did you save as current version? If Yes - then finish the current macro by emailing it out If No - Save As function and then when the user saves it in their own designated folder, then complete the macro that is already there emailing it out. Does that make sense? This is my current macro: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Save without the Save Message | Excel Discussion (Misc queries) | |||
Disable save & save as then return message... | Excel Programming | |||
How do I bypass the message to save when closing a file by macro? | Excel Programming | |||
Can I run a message box Macro on Save in Excel? | Excel Programming | |||
How to save file without the save message? | Excel Programming |