by JE McGimpsey <jemcgimpsey@[EMAIL PROTECTED]
>
Apr 28, 2008 at 11:56 AM
In article <ee99c43.-1@[EMAIL PROTECTED]
>,
christinaNnyc@[EMAIL PROTECTED]
wrote:
> I'm trying to protect an excel sheet so no one can open it without a
> password. Can someone help?
You can use Tools/Protection/Protect Sheet..., but be aware that there
is NO way to protect a sheet so that "no one can open it".
XL's internal protection is suitable for distributing to very honest (or
lazy) novices, but can be bypassed in about 30 seconds:
http://www.mcgimpsey.com/excel/removepwords.html
And workbook protection doesn't take much longer:
http://www.mcgimpsey.com/excel/fileandvbapwords.html
The only really secure way to protect a workbook is to create it as a
COM add-in. Unfortunately, that capability doesn't exist on the Mac.