Incrementing an invoice number and saving its value is a frequent task.
Using CustomDocumentProperties (CDPs) is a good method to store such numbers in a relatively safe way within the same work book, but avoiding to show related cell values simply in an unprotected work sheet.
Additional hint:
A...