Please, i need non-volatile way to: When workbbook is opened, put today's date in cell F1, when i click on exit or close Excel, remove value from F1. But, without that Excel message "Do you want to save chan......".? Please, hellp.
Basically, when workbook is active, show date in cell F1, when i close it, remove Date, to have it w/o exit message.
So, my question is impossible. Unless, clicking excel message box on exit or, disabling auto calculate option. Originally, I needed today function to check date and display today's date, if not then blank cell.
Code is fine, BUT i lost Save message on other data, when i enter manually other cell values(on other sheets) i lost Save message on exit[Blocked Image: http://www.mrexcel.com/forum/images/smilies/frown.png]