You can change the security level to the lowest (MS doesn't recommend this) or
you could digitally sign the workbook and then trust that author.

Time wrote:

Is there a way that I can enable the macro without the popup box showing up
prompting if I would like to diable or enable macro?

"Dave Peterson" wrote:

Like the event macro like the one that JE McGimpsey shares:
http://www.mcgimpsey.com/excel/timestamp.html

Seems like a good idea.

Time wrote:

So I was given this formula from this online help (very grateful by the way,
thanks for the help!!):

=IF(A1="","", IF(B1="", NOW(), B1))

But the thing is, it is a shared workbook. So when I hit save on my
computer, it does not reflect the time that "cell A1" was originally entered,
but rather the time it showed up "updated" on my computer. How can I prevent
this from happening? Would it be easier to put in the worksheet_change event
that I've been reading about on this site? Whichever is simpler will do.
Thanks for all the help everyone.

--

Dave Peterson


--

Dave Peterson