Hi All

I'm not majorly new to VBA, but this is the first time in a while I have tried to create a Macro in Excel 2003.

What I need is for a button I have on a sheet, that when clicked, the column lets say D is shifted to the right (in essence a new column is inserted) and the header is changed from D to todays date

I have the insert cells programmed fine, but does anyone know how to change the column header from D to todays date. I know it can be done in Excel 2007 as I've used a workbook that did exactly that, but I cannot get it to work in 2003

Thanks