Forum Discussion
Solved
MAKE RESULT OF TODAY() AND NOW() FORMULAS STATIC IN A CELL
I need to convert the date and time values from TODAY() and NOW() formulas into static values into specific cells in a template. This has to be protected, in order to prevent the user of the workbook...
Excel works live on data. So you can't stop it from calculating and updating a particular cell.
However, this is achievable via macro. The work around is that you write a macro where you select a cell (your entry date calculated via TODAY() or NOW() function) and press a button, which will replace the formula with the resultant value.
However, this is achievable via macro. The work around is that you write a macro where you select a cell (your entry date calculated via TODAY() or NOW() function) and press a button, which will replace the formula with the resultant value.
- Thanks!
