Date problem

N

nabil

I'm resending this reply since I noticed I answered to
someone who replied to you and not to you:

We solved this with a small VB routine that uses an event
called WorkbookBeforeSave. Make the routine write a
date/time stamp on the target cell when the adjacent or
referenced cell takes on a desired value (i.e: ISNOTBLANK,
TRUE, FALSE, =1, etc.). WorkbookBeforeSave checks whether
the contents have changed everytime you re-open the
wkbook: if they are still the same the original date/stamp
will not be changed(as happens with today() or now())and
will remain for future reference. Works beautifully. If
you'd like the actual VB routine, e-mail me.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert date & time when 5 condition are true 4
Date Stamp in Last Column in active row if any data changes in row 1
date stamp with protected cells problem 0
Multiple Date Stamp & Worksheet Change macros 1
Using colour conditional formatting to show whether due date has past 0
Questing regarding Date Stamp 2
Time Stamp 8
Generate web address string from date range in column? 10

Top