Code in one Workbook effecting another Workbook

[gsandy]

I am using the following code to save one workbook (Timer.xlsm) at a regular interval. As well it puts a time in cell B3.
This code runs while I am working on other workbooks. The problem is that while in the other workbook, and when "SaveThis" runs, the time is placed in cell B3 of the 2nd workbook.
How can I modify the code to ensure the time only goes in B3 of Timer.xlsm?
Thanks Sandy

Please Login or Register  to view this content.

[AlphaFrog]

Change the sheet name to suit.

Please Login or Register  to view this content.

[oluapseyer]

Try this one

Please Login or Register  to view this content.

Change "Sheet1" to the actual name of the sheet you want to display the Time

[gsandy]

Thanks Guys that worked, no problems now. Cheers Sandy