software

I have password protected an Excel worksheet but it can still be accessed
without using the password, and is therefore not protected! Any ideas?


Hi Dona,

When you set the password make sure you uncheck the box 'Allow Users to
select locked cells'. Obviously the cells need to be formatted to
protected.

HTH

Ed--
EdMac
------------------------------------------------------------------------
EdMac's Profile: www.excelforum.com/member.php...oamp;userid=30736
View this thread: www.excelforum.com/showthread...hreadid=520986Protecting a worksheet won't stop users from accessing that worksheet--but it
will stop them from changing locked cells on that worksheet.
dona wrote:
gt;
gt; I have password protected an Excel worksheet but it can still be accessed
gt; without using the password, and is therefore not protected! Any ideas?

--

Dave Peterson


When you say 'Accessed' do you mean open it or change it.

If you mean change it then my reply above applies. If you want to stop
it being opened then use 'Save as' and apply the option to password
protect it. Bear in mind that the Windows password protection system
can be got around with a little knowledge--
EdMac
------------------------------------------------------------------------
EdMac's Profile: www.excelforum.com/member.php...oamp;userid=30736
View this thread: www.excelforum.com/showthread...hreadid=520986Since the OP was writing about a worksheet (not a workbook), I read accessed as
view.

EdMac wrote:
gt;
gt; When you say 'Accessed' do you mean open it or change it.
gt;
gt; If you mean change it then my reply above applies. If you want to stop
gt; it being opened then use 'Save as' and apply the option to password
gt; protect it. Bear in mind that the Windows password protection system
gt; can be got around with a little knowledge
gt;
gt; --
gt; EdMac
gt; ------------------------------------------------------------------------
gt; EdMac's Profile: www.excelforum.com/member.php...oamp;userid=30736
gt; View this thread: www.excelforum.com/showthread...hreadid=520986

--

Dave Peterson

Thanks,

that seems to be working OK now. I appreciate your help.

Dona.

quot;EdMacquot; wrote:

gt;
gt; Hi Dona,
gt;
gt; When you set the password make sure you uncheck the box 'Allow Users to
gt; select locked cells'. Obviously the cells need to be formatted to
gt; protected.
gt;
gt; HTH
gt;
gt; Ed
gt;
gt;
gt; --
gt; EdMac
gt; ------------------------------------------------------------------------
gt; EdMac's Profile: www.excelforum.com/member.php...oamp;userid=30736
gt; View this thread: www.excelforum.com/showthread...hreadid=520986
gt;
gt;