protect a workbook from being deleted

Can someone tell me if I can prevent an Excel workbook from being deleted
from my file without some sort message being sent to verify this request?

If the workbook is in a shared folder on your C drive and you have administrator rights on your machine, then you can set permissions for the types of actions (i.e. create files, delete files, read files, etc.) and which users can access the shared folder. To do this, open Windows Explorer, navigate to the shared folder and right-click on it and select Properties. On the Security tab, you can Add/Remove users, and if you click the Advanced button you can set the permissions you want.

If the file is on a network server, your network administrator can set the permissions and who has access.

Hope this helps,
theDude

Toni

A workbook is a file.

Do you mean prevent a worksheet from being deleted from a workbook?

The alert message is built-in. When you try to delete a sheet you are asked
if you really want to do this.

If that is not sufficient, Protect the workbook under Tools>Protection>Protect
Book.

No way can a sheet be deleted unless the protection is removed. You would
place a password to unprotect for sheet deletion.

Note that workbook protection passwords are easily cracked.

If none of the above assists, post back with your exact needs. There may
another way.


Gord Dibben Excel MVP

On Wed, 12 Jan 2005 10:05:08 -0800, "Toni's Taxi" <Toni's
Taxi@discussions.microsoft.com> wrote:

>Can someone tell me if I can prevent an Excel workbook from being deleted
>from my file without some sort message being sent to verify this request?