Auto update all dates in a column to todays date on workbook open

Hi, thanks for your help.

Unfortunately it didn't work. Is it because I placed the code in the module for a sheet within the workbook not in "ThisWorkbook"? I should have said but I don't want the code to affect the entire workbook, just the issue/task tracking sheet within this workbook.

Cheers

Sam

Just tried your suggestion pjwhitfield.

Capture.PNG

Not sure why the third line down has a problem??