Forum Discussion

iantb0070's avatar
iantb0070
Copper Contributor
Apr 24, 2022

lock date

I'm trying to lock the date to the date that particular workbook was created. I create many estimates for work, at the moment the date displays todays date, but if i open it again tomorrow, it will d...
excel
HansVogelaar's avatar
HansVogelaar
MVP
Apr 24, 2022

iantb0070 

I'd enter the data manually: press Ctrl+; to insert the current date as a fixed value.

 

It would also be possible to use VBA code, but that is overkill IMHO.

  • ilker_zc's avatar
    ilker_zc
    Copper Contributor
    Apr 24, 2022
    •  
    • iantb0070's avatar
      iantb0070
      Copper Contributor
      Apr 24, 2022

      ilker_zc 

      Thanks, i was just trying to make it easier, but I thought that's what i would have to do, THANK YOU.

       

Resources