Is there a reason why you can't just dedicate a cell in a
read only workbook. Add 1 within the initial
Public Sub Workbook_Open()
End Sub
You could, theoretically create a shortcut on a desktop
thatopens an excel file automatically in read only mode
using
/r workbook_path/file_name

-----Original Message-----
Hi All,

1) Is it possible to generate a Unique No Code (e.g
RV00001) in a cell so
that whoever accesses that file and when he saves it as
some other filename,
gets a unique no on his excel copy & that unique no is
also retained as the
last-no-used on the original excel sheet.

2) Now whatever he entered will be automatically
entered on a diff
workbook's worksheet called say the 'Database' & in a
database like manner,
i.e Records(rows of records).

I am new to VBA & not quite used to it. See my
post "Creating a Database" as
of nov 15th.

Could anybody help me on this?

Thanking you in advance,


Eijaz


.