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: |
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: |
All times are GMT +1. The time now is 07:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com