sorry I am very unfamiliar with this website and am probably directing this question to the wrong person, however I hope you can help! I utilised the advice given on the following link http://en.allexperts.com/q/Excel-1059/automatic-progressive-invoice-numbers.htm and it was great advice that works perfectly!!! However my problem is that when an actual invoice is created then saved, the number keeps progressing if the saved invoice is reopened! Is there anything that can be done to fix the invoice number when its saved (without doing the reverse of the procedure)????
I am not sure what all is going on with the VBA code, but it sounds as though the invoice is being saved with the formula in it that changes the invoice. Try saving it by useing the copy paste special feature copy and do a copy/paste special/values then a copy/paste special/formats. This should eliminate the changeing of the invoice number on a saved invoice. However there would be a better way of doing this by including the process in the VBA code. If the copy paste special doesn't work for you, I suggest you go back to the allexperts site and see if xeonflux is still listed as an expert. He/she would be the best person to ask about changing the code to work for you.
Hope this helps.