Hello,

Using this website and my knowledge i have made the following Macro:
Sub Button_Click()
Range("D15").Value = "COMPLETED"
Range("H43").Value = Date
Range("C16").Formula = "=Delivery!$C$16"
Sheets(Array("Delivery")).PrintOut Copies:=1
End Sub
However I want this to run when Cell E5 is clicked on.
Also the date is currently displayed as 30/07/2013.
I would like the date to display 30.07.13 - is there any way to change this?

Thanks
Darren