Hello there, i'been posting this same question in almost every excell forum
without am accurate answer, I'm almost givin up!
I have this code for auto increment cell "E5" upon open an invoice template:
Private Sub Workbook_Open()
[E5] = [E5] + 1
End Sub
All I need its a piece of code that saves the file right after cell increment
without asking me (no "save as" window). just simply save itself , that way it will always keep the last number of the sequence.
It's that possible?
without am accurate answer, I'm almost givin up!
I have this code for auto increment cell "E5" upon open an invoice template:
Private Sub Workbook_Open()
[E5] = [E5] + 1
End Sub
All I need its a piece of code that saves the file right after cell increment
without asking me (no "save as" window). just simply save itself , that way it will always keep the last number of the sequence.
It's that possible?