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
- Aug 07 Thu 2008 20:45
Protecting Worksheets
close
全站熱搜
留言列表
發表留言
留言列表

