Prevent user deleting an XLS file

[helmekki]

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

[MC]

Hi helmekki,

Noone else has answered so I will take a shot!

No, can only be accomplished by setting rxwd permissions.

MC

"helmekki" <helmekki.22d56m_1138482601.0678@excelforum-nospam.com> wrote in
message news:helmekki.22d56m_1138482601.0678@excelforum-nospam.com...
>
> 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]

Thank u 4 reply

how to set rxwd permissions ?

[Tim Williams]

Just give the user read-only access to the file.

Tim

"helmekki" <helmekki.22e5iy_1138529701.3439@excelforum-nospam.com> wrote in
message news:helmekki.22e5iy_1138529701.3439@excelforum-nospam.com...
>
> 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
>