+ Reply to Thread
Results 1 to 4 of 4

not all cells are locked when protect is true for work sheet

  1. #1
    Alexandre Brisebois (www.pointnetsolutions.com)
    Guest

    not all cells are locked when protect is true for work sheet

    not all cells are locked when protect is true for work sheet how can i
    fix that ?

    this is how i lock

    ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
    Scenarios:=True

    some cells with comments or empty cells are not protected... how can i
    fix this?


  2. #2
    Paul B
    Guest

    Re: not all cells are locked when protect is true for work sheet

    Alexandre, sounds like some of the cells are not locked, select all the
    cells then format, cells, protection, lock
    --
    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

    "Alexandre Brisebois (www.pointnetsolutions.com)"
    <[email protected]> wrote in message
    news:[email protected]...
    > not all cells are locked when protect is true for work sheet how can i
    > fix that ?
    >
    > this is how i lock
    >
    > ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
    > Scenarios:=True
    >
    > some cells with comments or empty cells are not protected... how can i
    > fix this?
    >




  3. #3
    Alexandre Brisebois (www.pointnetsolutions.com)
    Guest

    Re: not all cells are locked when protect is true for work sheet

    thanks paul it was the solutions, now i have about 40 sheets to do this
    on

    Regards,
    Alexandre


  4. #4
    Dave Peterson
    Guest

    Re: not all cells are locked when protect is true for work sheet

    If those 40 sheets are in the same workbook, you can group the worksheets by:
    clicking on the first worksheet tab and ctrl-clicking on the subsequent

    or
    rightclick on a worksheet tab and choose "select all sheets"

    Then hit ctrl-a (twice in xl2003) to select all the cells (on all the grouped
    sheets)

    format|cell|protection tab
    and change the setting to Locked.

    And remember to ungroup the sheets (rightclick on one of the tabs and choose
    ungroup sheets. (If you forget, then each change you make will be made to each
    of the grouped sheets. So be careful.)

    "Alexandre Brisebois (www.pointnetsolutions.com)" wrote:
    >
    > thanks paul it was the solutions, now i have about 40 sheets to do this
    > on
    >
    > Regards,
    > Alexandre


    --

    Dave Peterson

+ 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