+ Reply to Thread
Results 1 to 4 of 4

Protected Sheets

  1. #1
    Jolo
    Guest

    Protected Sheets

    How do I allow other useres to be able to go in and insert comments on a
    sheet that I have certain cells protected because I do not want them to alter
    the formulas?

  2. #2
    Paul B
    Guest

    Re: Protected Sheets

    Jolo, depends on what version you have, try this, when you go to protect the
    sheet check edit objects

    --
    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

    "Jolo" <[email protected]> wrote in message
    news:[email protected]...
    > How do I allow other useres to be able to go in and insert comments on a
    > sheet that I have certain cells protected because I do not want them to

    alter
    > the formulas?




  3. #3
    Jolo
    Guest

    Re: Protected Sheets

    Thank you It worked. I have been busting my head all day on this. Thanks

    "Paul B" wrote:

    > Jolo, depends on what version you have, try this, when you go to protect the
    > sheet check edit objects
    >
    > --
    > 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
    >
    > "Jolo" <[email protected]> wrote in message
    > news:[email protected]...
    > > How do I allow other useres to be able to go in and insert comments on a
    > > sheet that I have certain cells protected because I do not want them to

    > alter
    > > the formulas?

    >
    >
    >


  4. #4
    Paul B
    Guest

    Re: Protected Sheets

    Your welcome, thanks for the feedback

    --
    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

    "Jolo" <[email protected]> wrote in message
    news:[email protected]...
    > Thank you It worked. I have been busting my head all day on this. Thanks
    >
    > "Paul B" wrote:
    >
    > > Jolo, depends on what version you have, try this, when you go to protect

    the
    > > sheet check edit objects
    > >
    > > --
    > > 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
    > >
    > > "Jolo" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > How do I allow other useres to be able to go in and insert comments on

    a
    > > > sheet that I have certain cells protected because I do not want them

    to
    > > alter
    > > > the formulas?

    > >
    > >
    > >




+ 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