lock formula

[Guest]

Hi,
I want to lock&hide some cells which contain formula, First I select the
cells I want people to access(change valuves) and choose
fromat/cells/protection&untick locked, then choose tools/protection/protect
sheet, add a password, But now the problem is i can not access to any cell
even unlocked ones.(I tried tick or Untick edit objects, failed).
Hope you can help me
Regards
ellen

 

[Peo Sjoblom]

Try this, select the whole sheet by clicking the select all button or press
Ctrl + A (if you have excel 2003 you might need to press Ctrl + A twice
since the first key press select the current region), now do
format>cells>protection and deselect locked, now select all cells you want
to protect, repeat but select locked, finally protect the sheet. That should
work


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com