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