Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Oct 2002
    Location
    Mornington Peninsula
    Posts
    42
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Angry

    Hi all,

    Need to have protection applied to a sheet to prevent other users overriding formulas etc. Seems once protection is applied, users then cannot sort the rows.

    For example, say users need to occasionally add new employees in staff listing and perhaps a start date, which they would add in the next available blank row. Then need to sort new rows into existing via alpha/numeric order.

    Is there any way to sort a protected sheet please? Or any other suggestions would be appreciated.
    Many thanks for any help, much appreciated.
    Have a great day!
    WebMistress

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    When you protect a worksheet, you can specify what the user is allowed to do. Sorting is among them. You have to scroll down the list to see the Sort check box.
    The user will only be able to sort unlocked cells.

    If you want to sort a range that includes locked cells too, you must provide a macro that sorts the sheet. If you protect the sheet in code, you can set UserInterfaceOnly to True so that macros can manipulate the sheet.
    Attached Images Attached Images
    • File Type: jpg x.jpg (28.0 KB, 0 views)

  3. #3
    Lounger
    Join Date
    Oct 2002
    Location
    Mornington Peninsula
    Posts
    42
    Thanks
    1
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='790433' date='24-Aug-2009 04:22']When you protect a worksheet, you can specify what the user is allowed to do. Sorting is among them. You have to scroll down the list to see the Sort check box.
    The user will only be able to sort unlocked cells.

    If you want to sort a range that includes locked cells too, you must provide a macro that sorts the sheet. If you protect the sheet in code, you can set UserInterfaceOnly to True so that macros can manipulate the sheet.[/quote]


    Many thanks, that's what I needed!
    Webmistress.
    Many thanks for any help, much appreciated.
    Have a great day!
    WebMistress

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •