password protection in Excel

D

dona

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

EdMac

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
 
D

Dave Peterson

Protecting a worksheet won't stop users from accessing that worksheet--but it
will stop them from changing locked cells on that worksheet.
 
E

EdMac

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
 
D

Dave Peterson

Since the OP was writing about a worksheet (not a workbook), I read accessed as
view.
 
Top