ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to make a file so that it can't be deleted from the system? (https://www.excelbanter.com/excel-programming/359662-how-make-file-so-cant-deleted-system.html)

[email protected]

How to make a file so that it can't be deleted from the system?
 
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


K Dales[_2_]

How to make a file so that it can't be deleted from the system?
 
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



[email protected]

How to make a file so that it can't be deleted from the system?
 
Thanks a lot!

I will take this as my reference.



All times are GMT +1. The time now is 12:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com