Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting protected worksheets

    Is it possible to sort a protected worksheet in Excel 97? I have protected the worksheet because users keep copying the formula lines all the way down to the bottom of the worksheet and it makes the file REALLY big. So, they can't do that any more, but they want to be able to sort. Any suggestions?

  2. #2
    Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting protected worksheets

    My only thought is that you can do it in VBA, with a subroutine along the lines of

    sub SortSheet()
    worksheets(1).unprotect password:=???
    range("a1:b500").sort key1:=range("a1")
    worksheets(2).protect password:=???
    end sub

    What I would suggest is that you record the macro, as the recording for a simple job like this will be fine.

    Sing out if you need further help.

    Jon

Posting Permissions

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