How to prevent macro from running in unintended workbooks

As long as I only have one workbook open, this macro works great, but every time this macro runs while I have other work books open, it runs in the current work book that is open, failing to do what it's intended to do, please see the below code.

Also- if you can offer any advice to help make this code more solid I would appreciate it. Thank you.
(I just added the "sheets("update").Select on the 1st line hoping that will solve the issue but I can not check to see if it's going to work becuse I am not at work right now, so I dont know if that will help.)

Please Login or Register  to view this content.

Please use code tags are around your code and provide us with a dummy workbook so we can test the resulting code (unless you want to debug).

Here is what I have so far (naturally... untested):

Please Login or Register  to view this content.

Q1) what is setDate and TimeUp? Should they be the same thing?

The TimeUp refers to the following code, its the same thing. This is to keep a clock active that will show how long it has been since the sheet has been updated.

Please Login or Register  to view this content.

OK. Let me know if you have any questions or problems. If not, then please mark the thread as solved.

For this line

Please Login or Register  to view this content.

how do I get it to "paste" the values only?

This is copying a formula which is for a hyperlink and is used for the email address, the address is pulled from B2:B941 and I have trouble getting the emails to send with anything other than plain text.

Thanks for your help on this.

Try this:

Please Login or Register  to view this content.

Siray, you need to add code tags to your first post and use Code Tags not HTML Tags. This is explained if you bother to read theForum Rules

Thanks for the feedback and marking the thread as Solved.

Good luck.

abousetta