• Sorting protected worksheets

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Sorting protected worksheets

    Author
    Topic
    WSLisaH
    AskWoody Lounger
    January 18, 2001 at 5:07 pm #352035

    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?

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSJon Holbrook
      AskWoody Lounger
      January 18, 2001 at 6:56 pm #510914

      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

      Reply | Quote
    Viewing 0 reply threads
    Reply To: Sorting protected worksheets

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.