ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Prevent user deleting an XLS file (https://www.excelbanter.com/excel-programming/351718-prevent-user-deleting-xls-file.html)

helmekki[_125_]

Prevent user deleting an XLS file
 

Hi there

Is there a vba code to prevent user deleting an XLS file when the file
is closed and the XL app is closed

i.e. simpley prevent deleting the file while it is closed


--
helmekki


------------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=506062


MC[_5_]

Prevent user deleting an XLS file
 
Hi helmekki,

Noone else has answered so I will take a shot!

No, can only be accomplished by setting rxwd permissions.

MC

"helmekki" wrote in
message ...

Hi there

Is there a vba code to prevent user deleting an XLS file when the file
is closed and the XL app is closed

i.e. simpley prevent deleting the file while it is closed


--
helmekki


------------------------------------------------------------------------
helmekki's Profile:
http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=506062




helmekki[_126_]

Prevent user deleting an XLS file
 

Thank u 4 reply

how to set rxwd permissions ?


--
helmekki


------------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=506062


Tim Williams

Prevent user deleting an XLS file
 
Just give the user read-only access to the file.

Tim

"helmekki" wrote in
message ...

Thank u 4 reply

how to set rxwd permissions ?


--
helmekki


------------------------------------------------------------------------
helmekki's Profile:
http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=506062





All times are GMT +1. The time now is 08:10 AM.

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