Automate todays date upon open workbook

[TimlmiT]

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

[mehmetcik]

Try date instead of today()

Please Login or Register  to view this content.

[TimlmiT]

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