View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sandy Sandy is offline
external usenet poster
 
Posts: 270
Default Don't want date to update

In cell A10 I have the formula =Today() which is fine, but how can I code
it so that when the file is saved the value in A10 at the next opening
doesn't update. (I know to use the "BeforeClose" sub procedure). In other
words it retains the date that the file was saved.
Sandy