change a number when document is edited & saved

[vashra]

Hello,
Can someone tell me how do i do this in Excel:
1. A field has a number for example 0001 which has to be protected, because it is a ref number.
2. When the document is edited and saved, that field of point 1 has to increase to 0002.

Thanks in advance

[TMS]

1. You'd protect the cell by locking it and protecting the sheet with a password. To update it, typically, the code would unprotect the sheet, increment the value and reprotect the sheet.

2. You would increment the reference number in the Workbook Before Save event. Either include the code directly or call a subroutine in a standard module.


I suggest you post a sample workbook for more specific assistance.


Regards, TMS