+ Reply to Thread
Results 1 to 2 of 2

Locking formulas

  1. #1
    Margaret DS
    Guest

    Locking formulas

    I am creating an order form in Excel for clients. I have protected the text
    in selected cells so the cells can't be accessed. I also want to lock the
    formulas in other selected cells so the formulas can't be deleted, changed,
    etc. How can this be done?

  2. #2
    Paul B
    Guest

    Re: Locking formulas

    Margaret, unless I am missing something, protect the cells with the formulas
    the same as you did for the text
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "Margaret DS" <Margaret [email protected]> wrote in message
    news:[email protected]...
    >I am creating an order form in Excel for clients. I have protected the
    >text
    > in selected cells so the cells can't be accessed. I also want to lock the
    > formulas in other selected cells so the formulas can't be deleted,
    > changed,
    > etc. How can this be done?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1