Question Locked
Autonumber Macro that disables when file saved?
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a macro on an excel workbook which increases the document number (in a Cell) by 1 each time the file is opened. However when that file is then saved as number X and then re-opened it becomes X+1. However i need the file to stay as Number X as that is that files designated unique number. Anyone have any ideas on this as i am stumped!