Protecting a workbook

[Sasikiran]

Dear Concerned,

Is there any way where an entire workbook is protected by a password which
allows opening of the workbook only on entry of that password and no one else
could also delete that file?

Please let me know if there's any such option in the excel.

Thanks in advance.

 

[Gord Dibben]

You can password to open but you cannot prevent anyone from deleting the file
unless they don't have permissiom to access or delete files from that folder on
the computer.

i.e. if they can access the folder and file through Windows Explorer or through
File>Open dialog in Excel, they can delete the file.

See Windows Help for how to limit users from accessing folders and files.


Gord Dibben MS Excel MVP