How to fix a Date value in excel cell? Explanation: I have a file with a VB macro who put a 'TODAY' value in a cell when i click a button. but! i would like to lock the value.. So if i open the file tomorrow it will be the same value.. Lol i hope it's clear enough.. Thanks to try to help me..
You'll have to go in and modify the VBA code in the Click event off the button. I'd create a second button if you want Today's date in the cell, and disable it from the first button.