View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stan Brown Stan Brown is offline
external usenet poster
 
Posts: 524
Default Protecting Entire Workbook from Deletion

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.


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.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/