I just want to get invoice no. to be incremented by 1, I am using below VBA code to perform this
Private Sub Workbook_Open()
Range("D3").Value = Range("D3").Value + 1
End Sub
But here the problem is whenever i opened this excel file to see some information, the invoice no. get incremented,
Please suggest me some code so that whenever i copied the workbook and rename, Only then the invoice no. will increment by 1.

