+ Reply to Thread
Results 1 to 4 of 4

Block Protect

  1. #1
    RhysPieces
    Guest

    Block Protect

    I want to protect a block of cells on a worksheet of a shared workbook. How
    to do this without protecting the entire sheet? If not, I will protect whole
    'sheet.

  2. #2
    R. Choate
    Guest

    Re: Block Protect

    Protect the sheet but then unprotect all of the cells (within a reasonable range) other than the cells you want protected. You have
    to protect the sheet to activate protection, but then you can protect or unprotect ranges within the sheet. I mentioned unprotecting
    a reasonable range because oftentimes, if you do anything that includes all of the columns to # 256 and all of the rows down to
    65,000 (approx.), then you can unintentionally get file size bloat. So just unprotect the area where people might actually do
    something and ignore the excess area that nobody will touch anyway.

    HTH
    --
    RMC,CPA


    "RhysPieces" <RhysPieces@discussions.microsoft.com> wrote in message news:C0AA9EC1-8FDA-465D-BC4A-9CADF530CD12@microsoft.com...
    I want to protect a block of cells on a worksheet of a shared workbook. How
    to do this without protecting the entire sheet? If not, I will protect whole
    'sheet.



  3. #3
    RhysPieces
    Guest

    Re: Block Protect

    OK, the whole sheet is protected. How do I select a specific range to
    unprotect it or allow limited editing depending on the rules I establish
    while keeping certain cells protected from any changes?

    "R. Choate" wrote:

    > Protect the sheet but then unprotect all of the cells (within a reasonable range) other than the cells you want protected. You have
    > to protect the sheet to activate protection, but then you can protect or unprotect ranges within the sheet. I mentioned unprotecting
    > a reasonable range because oftentimes, if you do anything that includes all of the columns to # 256 and all of the rows down to
    > 65,000 (approx.), then you can unintentionally get file size bloat. So just unprotect the area where people might actually do
    > something and ignore the excess area that nobody will touch anyway.
    >
    > HTH
    > --
    > RMC,CPA
    >
    >
    > "RhysPieces" <RhysPieces@discussions.microsoft.com> wrote in message news:C0AA9EC1-8FDA-465D-BC4A-9CADF530CD12@microsoft.com...
    > I want to protect a block of cells on a worksheet of a shared workbook. How
    > to do this without protecting the entire sheet? If not, I will protect whole
    > 'sheet.
    >
    >
    >


  4. #4
    Peo Sjoblom
    Guest

    Re: Block Protect

    Unprotect it, select the range you want to allow editing in, do
    format>cells>protection and de-select locked, then protect the sheet

    --

    Regards,

    Peo Sjoblom

    http://nwexcelsolutions.com


    "RhysPieces" <RhysPieces@discussions.microsoft.com> wrote in message
    news:418548BD-AE80-40B0-BA56-FA1B761BD000@microsoft.com...
    > OK, the whole sheet is protected. How do I select a specific range to
    > unprotect it or allow limited editing depending on the rules I establish
    > while keeping certain cells protected from any changes?
    >
    > "R. Choate" wrote:
    >
    >> Protect the sheet but then unprotect all of the cells (within a
    >> reasonable range) other than the cells you want protected. You have
    >> to protect the sheet to activate protection, but then you can protect or
    >> unprotect ranges within the sheet. I mentioned unprotecting
    >> a reasonable range because oftentimes, if you do anything that includes
    >> all of the columns to # 256 and all of the rows down to
    >> 65,000 (approx.), then you can unintentionally get file size bloat. So
    >> just unprotect the area where people might actually do
    >> something and ignore the excess area that nobody will touch anyway.
    >>
    >> HTH
    >> --
    >> RMC,CPA
    >>
    >>
    >> "RhysPieces" <RhysPieces@discussions.microsoft.com> wrote in message
    >> news:C0AA9EC1-8FDA-465D-BC4A-9CADF530CD12@microsoft.com...
    >> I want to protect a block of cells on a worksheet of a shared workbook.
    >> How
    >> to do this without protecting the entire sheet? If not, I will protect
    >> whole
    >> 'sheet.
    >>
    >>
    >>




+ 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