Sounds like you would need code in the workbook to enforce this (assuming
that the user doesn't disable macros or the security setting disables them).

See Chip Pearson's page on events
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"bigdaddy3" wrote in message
...
can someone help i want to input data into a worksheet 3 columns, first a
ref
no, second a name, third a surname. Save sheet. When open new sheet
require
the first ref no to be added auto but +1 and so on for further sheets.
--
BD3