Hi all

I have an excel spreadsheet that contains a field that we at present
manually update and therefore have to keep checking the last sequence number
used.
I would like to somehow create a way to auto update the field so that when
opened the file will update the number (similar to purchase order
sequencing). The field will also need to be secure so that it cannot be over
written.

Any idea's ?