Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Mac > Excel Office for Mac > Re: how do I pa...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 2 Topic 5540 of 6461
Post > Topic >>

Re: how do I password protect an excel sheet?

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.
 




 2 Posts in Topic:
how do I password protect an excel sheet?
christinaNnyc@[EMAIL PROT  2008-04-27 19:41:32 
Re: how do I password protect an excel sheet?
JE McGimpsey <jemcgimp  2008-04-28 11:56:06 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Oct 11 19:18:39 CDT 2008.