Please Login or Register  to view this content.
I have the above code which gets the date for the monday of the week in to a cell, if you open the file in that week. However I thought once it was saved, then it would stay the same, however, it keeps getting overwritten. I want to get it to remain as the date it captures for that week.

The only idea i can think of is :
1.Create the date using vba.
2.Make a button to insert it when creating the document.

Is this the quickest, easiest way? I was hoping that no manual interference would be needed.

Thanks for any help

Mark