Excel 2002 - locking forumlas - Geeks to Go Forums

Jump to content

Log in Register Register Malware removal guide How it works

Excel 2002 - locking forumlas

#1 ARO-RS3

  • Group: Member
  • Posts: 6
  • Joined: 14-August 12

Posted 15 August 2012 - 08:55 AM

I have a spreadsheet that I want to lock the formulas in so they cannot be edited, deleted, etc. But I want to be able to allow the user to enter data in certain fields. Can I lock cells and only allow the user to edit certain cells? If so, how?

#2 myrti

  • Group: GeekU Moderator
  • Posts: 2,071
  • Joined: 10-November 09

Posted 15 August 2012 - 09:03 AM

Hi,

yes that is possible. Have a look here: http://support.microsoft.com/kb/214081

regards myrti

Share this topic:


Page 1 of 1