"Frank abel" wrote:

Hi
I doubt this is possible (prevented by the Operating
System). If a file is opened by another user this can't be
over-written (in addition what should happen for the user
who has opened this file: automatic closing of Excel or
automatic replacing?).

So AFAIK this is not Excel specific but restricted by the
OS
Some ideas for a workaround:
-maybe use a shared Excel file (and live with the
restrictions of this feature)
- use a different type of application (e.g. database)

Frank.. frankly i think you're confused !

if any program (including Excel) opens a file as readonly
it IS readonly.. and any program or user can delete it
(if it has permission from the filesystem in that directory)

Test:
new workbook
save as ro.xls
close
open readonly ro.xls (in xlXP dropdown the open button)
(in xl97 use option button (topright)

in explorer = delete the file.



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool