You have another (similar) suggestion at your other thread.

Michael Link wrote:

I guess this is part 2 of a query I started below. I need a macro that will
enter both the current date and time into the active cell whenever it is run.
Since this is for a workbook shared across a network, the information needs
to remain unchanged in the cell even if the macro is run for another active
cell by someone else on the network.

Help! I've recorded or written very few macros, and unfortunately I need to
have this one running as soon as possible. Thanks in advance for your help,
and thanks to the folks who offered assistance to a related date/time query
earlier today.

--

Dave Peterson