Testing output of one Function with another

Hi flebber;
I don't work in XL2007, so if my observations don't make sense, just ignore them.
1) LastSaved will ALWAYS be before Now. There is no way in the world that the file was saved at some time in the future.
I'm guessing that you want to check LastSaved against the value stored in D4.
Also, LastSaved should return a Date not a string.

Please Login or Register  to view this content.

2) The following code will "Do Nothing" if some test is true

Please Login or Register  to view this content.

or usually more effieciently

Please Login or Register  to view this content.

3) What is this line supposed to do?

Please Login or Register  to view this content.

I'm guessing that you want to put Now into D4. If so then:

Please Login or Register  to view this content.

4) If you want DateTime() to work on Workbook_Open you need this sub in ThisWorkbook module
And put DateTime into a Standard Module and don't make it Private (otherwise Workbook_Open() won't find it).

Please Login or Register  to view this content.

5)
I'm guessing that when you say:

Then test if one of two merged cells contains text and keep testing until it does and then insert time in cell.

you mean that when the file opens to keep testing the cell until it changes.
If that is right, there is a MUCH more efficient way to do it.
Assuming that the cell to test is G3, put this in Sheet 1 module

Please Login or Register  to view this content.

6) Don't know what you mean by this line.

Third try to ensure date does not update when file reopened unless user manually writes date or time.

The file will always be reopened whenever the file is opened (except when it's first being created).

Originally Posted by flebber

Regarding point 6 all I meant to say was that I didn't want the date to update everytime the workbook opens after the intial save I will be creating a function to save file as "some_username_Month_Year". If a user opened this file I don't want the scorecard reference date to change again to new date.

I can't follow your logic. It would probably help, if you explained it in words. Like this.

I have a master file that I don't want altered.
When a user opens the master file and changes anything, I want the master file to automatically save the changes into a new file with a name that is constructed using the user's name and the current month & year, and never re-save itself.
The ONLY time I want the master file to allow itself to be re-saved is if the user manually entered a date into a specific cell.

Or something similar.