How could you make a counter for a cell that does not reset everytimethe program is opened?
Sorry, really no idea what you're asking. Please describe in much more detail.
If I understand, save the number in an unused cell and save the sheet.I do this to have "Preferences" in a sheet.
Write the code in Worksheet Change method for appropiate worksheet.