Time & date stamp when saving a shared worksheet

Hello Everyone!

Im wondering if it is possible to date & time stamp cell A1 when the document is saved, the document is shared.

Thank you for your time

Jamiec

hello,

Thanks for your quick reply! Im a bit of a novice, would you be able to run through how to get this into a worksheet please? im using 2007

Thanks again

can anyone give me any advise please??

Many Thanks

that other code i posted was CRAP... use this:

Please Login or Register  to view this content.

Hello,

Thanks for your reply, Thats works Great!!

I didnt work as a shared workbook though, is there any way around that so I can return it back to a shared doc

Many Thanks

I know of no reason why the macro shouldn't work however i think you need to unshare the file, employ the code, and then share the file again.

If that doesn't work try this:

Please Login or Register  to view this content.