Mehmud Khan
Member
Dear team,
Good Day!
Once again looking for help from this forum as most of my queries are resolved from here.
I am preparing a file wherein user has to update IN and OUT time.
The "Time Stamp" (in attached file) button will auto update the time in selected cell then same VBA will prepare email (within excel via Email Envelope) and user has to send the email manually by clicking "Send this Selection" as ".Item.Send" (in VBA) command is asking approval (taking 5 seconds to Allow, which I don't need)
My condition is, if user does not click on "Send this Selection" (if not send email) button then the time stamp (from last filled cell) should be cleared.
In simple words, It's mandatory to send email otherwise timestamp will be cleared.
I hope, I am able to explain the situations.
I have attached the file.
Thanks and Ward Regards
Good Day!
Once again looking for help from this forum as most of my queries are resolved from here.
I am preparing a file wherein user has to update IN and OUT time.
The "Time Stamp" (in attached file) button will auto update the time in selected cell then same VBA will prepare email (within excel via Email Envelope) and user has to send the email manually by clicking "Send this Selection" as ".Item.Send" (in VBA) command is asking approval (taking 5 seconds to Allow, which I don't need)
My condition is, if user does not click on "Send this Selection" (if not send email) button then the time stamp (from last filled cell) should be cleared.
In simple words, It's mandatory to send email otherwise timestamp will be cleared.
I hope, I am able to explain the situations.
I have attached the file.
Thanks and Ward Regards