SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Wizard
    Join Date
    Apr 2004
    Location
    dublin
    Posts
    2,036
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Excel + Locking Formulas

    Hi all,

    How do I lock certain cells containing formulas in MS Excel so that the user cannot edit them but can edit others?

    Thanks.

    Kevin.

  2. #2
    SitePoint Wizard Keriam's Avatar
    Join Date
    Jun 2003
    Location
    Colorado, USA
    Posts
    1,178
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    As far as I know, the only way you can lock certain cells (forumulas) requires that you protect then entire sheet first. Notice I said sheet, not workbook. So you could put all your formulas that you want to lock on a seperate sheet in the workbook and then protect them. This may not be the most elegant solution, but it will work. Perhaps someone else will have a better solution.
    Never put off until tomorrow what you can do
    the day after tomorrow. ~ Mark Twain


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •