ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Message box and Save as Macro (https://www.excelbanter.com/excel-programming/409936-message-box-save-macro.html)

Danielle0904

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:







Zack Barresse

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