Protecting Entire Workbook from Deletion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone please let me know if there's a way to protect a workbook from
being deleted (maybe a way to ask for a password before it's sent to the
recycle bin)? I am familiar with all other forms of protection, but have
never seen a way of preventing a file from being deleted totally.

Thanks!
 
You should be able to achieve this by using the windows securities.
This can be found by right clicking the file -> Properties ->
Security. If you give the everyone user only read and the read &
execute permissions and yourself full control with no other users then
no one other than your self will be able to change\delete the file.
 
Fri, 6 Jul 2007 13:18:01 -0700 from Missy43 <Missy43
@discussions.microsoft.com>:
Can someone please let me know if there's a way to protect a workbook from
being deleted (maybe a way to ask for a password before it's sent to the
recycle bin)? I am familiar with all other forms of protection, but have
never seen a way of preventing a file from being deleted totally.
Click to expand...

There's really no way to prevent a workbook from being deleted. You
can prevent it from being changed or deleted accidentally:

1. With the workbook closed, open My Computer and navigate down
the folder tree to the workbook.

2. Right-click, and select properties. Check Read Only and click
OK.

If you want to allow changes but not deletion, I don't know of any
way that's convenient. But I wouldn't worry about it. You're backing
up your system regularly, right? So if the workbook gets deleted you
can always restore it from a backup.
 
Back
Top