View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Zack Barresse Zack Barresse is offline
external usenet poster
 
Posts: 124
Default 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: