+ Reply to Thread
Results 1 to 4 of 4

protecting sheet blocking comment creation

Hybrid View

  1. #1
    Registered User
    Join Date
    02-22-2006
    Posts
    3

    protecting sheet blocking comment creation

    Hello Everyone, I'm set to release a budget sheet across my district, however, I've stumbled into a little last minute problem.

    I have to lock certain cells on this work sheet. Mostly the ones that have the formulas that work out the budget variances. However, a big part of this sheet is the use of comments (used to explain budget variances). When I protect the sheet, I can no longer add comments.

    Is there anyway to fix this?

    THANKS A TON

    -Amadis

  2. #2
    Paul B
    Guest

    Re: protecting sheet blocking comment creation

    Amadis, depends on what version you are using, when you go to protect the
    sheet under allow all users of this worksheet to: 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

    "Amadis" <Amadis.24dr2m_1141870200.8311@excelforum-nospam.com> wrote in
    message news:Amadis.24dr2m_1141870200.8311@excelforum-nospam.com...
    >
    > Hello Everyone, I'm set to release a budget sheet across my district,
    > however, I've stumbled into a little last minute problem.
    >
    > I have to lock certain cells on this work sheet. Mostly the ones that
    > have the formulas that work out the budget variances. However, a big
    > part of this sheet is the use of comments (used to explain budget
    > variances). When I protect the sheet, I can no longer add comments.
    >
    > Is there anyway to fix this?
    >
    > THANKS A TON
    >
    > -Amadis
    >
    >
    > --
    > Amadis
    > ------------------------------------------------------------------------
    > Amadis's Profile:

    http://www.excelforum.com/member.php...o&userid=31831
    > View this thread: http://www.excelforum.com/showthread...hreadid=520404
    >




  3. #3
    Registered User
    Join Date
    02-22-2006
    Posts
    3

    thanks

    Thank you so very much!

  4. #4
    Paul B
    Guest

    Re: protecting sheet blocking comment creation

    Your Welcome

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

    "Amadis" <Amadis.24e6cm_1141890001.2298@excelforum-nospam.com> wrote in
    message news:Amadis.24e6cm_1141890001.2298@excelforum-nospam.com...
    >
    > Thank you so very much!
    >
    >
    > --
    > Amadis
    > ------------------------------------------------------------------------
    > Amadis's Profile:

    http://www.excelforum.com/member.php...o&userid=31831
    > View this thread: http://www.excelforum.com/showthread...hreadid=520404
    >




+ 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