close

I have been trying to protect a worksheet to prevent it from being deleted.
I have tried the toolsgt;Protectiongt;Protect 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
quot;Kathy081403quot; gt; wrote in message
...
gt; I have been trying to protect a worksheet to prevent it from being
deleted.
gt; I have tried the toolsgt;Protectiongt;Protect Workbooks. I have selected
gt; Structure, however, the workbook can still be deleted without a password
or
gt; anything. Is the function not working?
gt; What am I doing wrong?
gt;
gt; Thanks,
gt;
gt; 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.

Toolsgt;Protectiongt;Protect Workbook.Gord Dibben MS Excel MVPOn Wed, 11 Jan 2006 10:00:04 -0800, quot;Kathy081403quot;
gt; wrote:

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

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()