Hi there,

I am a VBA user, currently working on a project which requires me to
system-lock a file. I couldn't find a way to do this. I need a file to
be created, let say "test.xls". This file finally has to be locked so
that only Administrator of the system (e.g. Win2K admin) can delete the
file. Otherwise, user who tries to delete the file from Windows
Explorer will see an error message saying that the file couldn't be
deleted (Windows error message). Appreciate any help! Thanks.

Hakimi

From Excel you could make the file read only but that would prevent changes
and also would be reversible. To securely prevent deletion it needs to be
set up by the Win2K admin: the admin needs to set up a folder with no
"delete" access rights where you can save the file.
--
- K Dales


" wrote:

Hi there,

I am a VBA user, currently working on a project which requires me to
system-lock a file. I couldn't find a way to do this. I need a file to
be created, let say "test.xls". This file finally has to be locked so
that only Administrator of the system (e.g. Win2K admin) can delete the
file. Otherwise, user who tries to delete the file from Windows
Explorer will see an error message saying that the file couldn't be
deleted (Windows error message). Appreciate any help! Thanks.

Hakimi

Thanks a lot!

I will take this as my reference.