I have been trying to protect a worksheet to prevent it from being deleted.
I have tried the toolsProtectionProtect Workbooks. I have selected
Structure, however, the workbook can still be deleted without a password or
anything. Is the function not working?
What am I doing wrong?

Thanks,

Kathy

Not possible to prevent a workbook from being deleted by doing something in
Excel, if you are on a network it can be prevented through the network
permissions. Think about it, if you send me a protected file shouldn't I be
able to delete that file without asking you for a password?


--

Regards,

Peo Sjoblom



"Kathy081403" wrote in message
...
I have been trying to protect a worksheet to prevent it from being
deleted.
I have tried the toolsProtectionProtect Workbooks. I have selected
Structure, however, the workbook can still be deleted without a password
or
anything. Is the function not working?
What am I doing wrong?

Thanks,

Kathy

Protecting a worksheet does not prevent deletion of that worksheet.

This protection only restricts editing and formatting of the sheet.

You must protect the workbook to prevent a worksheet from being deleted.

ToolsProtectionProtect Workbook.


Gord Dibben MS Excel MVP


On Wed, 11 Jan 2006 10:00:04 -0800, "Kathy081403"
wrote:

I have been trying to protect a worksheet to prevent it from being deleted.
I have tried the toolsProtectionProtect Workbooks. I have selected
Structure, however, the workbook can still be deleted without a password or
anything. Is the function not working?
What am I doing wrong?

Thanks,

Kathy