How to Prevent an Excel File from deletion by mistake/wantedly

[nirmalachr]

Good evening to the forum,

Actually i had made an excel file for sending automatic mails using outlook and that can be accessed by eveyone in my office, unfortunately today the file was deleted by somebody, luckily i was taking a backup of the file using batch file every one hour.

I would like to know any method or VBA code to prevent an excel file from deletion by other people in network.

Kindly help me.

Thanks in advance.

 

[AkaTrouble]

copy the file to a secure location and create a shortcut only allow users to have access to a shortcut to the file .... maybe

 

[nirmalachr]

copy the file to a secure location and create a shortcut only allow users to have access to a shortcut to the file .... maybe

Thank you AKA,

For timebeing i will use the same method and i request you to please proivde any kind of protection can be given to the file other than shortcut.

Once again thank you very much.

 

[AkaTrouble]

you could disable things using VBA but this would only prevent changes .. who ever is deleting the file is doing so outside of excel

you could add an automatic backup of file to either the file opening or file closing events and even add the user name as extension so you would know last user to open or close file

none of this would prevent the deletion using windows rather than excel

 

[Kyle123]

Stick it in a folder where users don't have rights to delete

 

[nirmalachr]

Stick it in a folder where users don't have rights to delete

Thank you