Automate todays date upon open workbook

Gurus,

I am looking to set a cell (K2) to todays date if cell (AE14) does not = 0, otherwise, I want cell (k2) to stay at its current date.

I have written the follow code in the Thisworkbook, but I don't know enough about VB to get it right. Please help.

Please Login or Register  to view this content.

TIA,
Tim

Try date instead of today()

Please Login or Register  to view this content.

Awesome! Thanks. However, it didn't work at first I had to put Quotations around AE14

Please Login or Register  to view this content.

Thanks Again!
Tim