+ Reply to Thread
Results 1 to 1 of 1

keeping sorting capabilities when protecting worksheet

Hybrid View

Kriman keeping sorting capabilities... 02-26-2009, 07:04 PM
  1. #1
    Registered User
    Join Date
    01-07-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    13

    keeping sorting capabilities when protecting worksheet

    Hi everybody,

    I protected an entire worksheet via TOOLS/PROTECTION/allow all users to select unlocked cells & sort. Also, I kept many columns unprotected via FORMAT/CELLS/PROTECTION/UNLOCK.

    However, the already implemented sorting capability via DATA/LIST/CREATE LIST is eliminated when I protect the sheet.

    So, does anybody know how to do the above steps but in a way that sorting will continue to function ????

    Otherwise....if not possible with the above steps.....what do you propose to do ????

    Many thanks,

    Alex
    Last edited by Kriman; 02-28-2009 at 01:23 AM. Reason: Being more specific

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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