+ Reply to Thread
Results 1 to 1 of 1

Sorting a table in protected worksheet

  1. #1
    Registered User
    Join Date
    10-24-2012
    Location
    Guelph, ON
    MS-Off Ver
    Excel 2010
    Posts
    41

    Sorting a table in protected worksheet

    Is it possible to sort a table that is in a protected worksheet? I would like the users to be able to sort by column B (Customer) in the table.

    The table has one column (A) that needs to remain locked or at least uneditable. All other columns are editable by the user and are unlocked. I have tried allowing sorting with the protection but can't get the sort function to work. We don't want the users to be able to unprotect the sheet because they could (and have in the past) made changes to table headers, etc. that mess up other things. I can also create a "sort" macro for them that will do this for them but thought I'd ask here first in case there is a simpler solution.

    Thanks,
    Stef.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sorting in Protected Worksheet
    By brentjohn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-08-2019, 08:10 AM
  2. Sorting a protected shared worksheet
    By Nigel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-25-2009, 05:55 AM
  3. Sorting protected shared worksheet
    By Nigel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-29-2008, 11:27 AM
  4. Sorting protected worksheet & workbook
    By Sue in forum Excel General
    Replies: 7
    Last Post: 09-23-2005, 09:05 AM
  5. Sorting Protected Worksheet
    By Vonner in forum Excel General
    Replies: 1
    Last Post: 07-16-2005, 11:05 AM
  6. Sorting on a protected worksheet
    By Sue in forum Excel General
    Replies: 6
    Last Post: 06-12-2005, 05:05 AM
  7. Sorting cells in a protected worksheet.
    By stormfinch2 in forum Excel General
    Replies: 0
    Last Post: 03-29-2005, 11:52 AM

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