Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Sort a Protected Worksheet

  1. #1
    Join Date
    4th February 2010
    Posts
    16

    Sort a Protected Worksheet

    When I protect the worksheet I select allow users to Sort, but every time I try I get an error that the worksheet is protected. This is Excel 2003.

    Any ideas?

    Thanks

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    2nd March 2010
    Location
    Springfield, IL
    Posts
    191

    Re: Sort a Protected Worksheet

    Based on the Help information in Excel 2003, the Allow all users to Sort option in the Worksheet Protection dialog merely makes the Sort menu functions available. If you try to sort a range that has protected cells the sort will fail because of the protection.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    4th February 2010
    Posts
    16

    Re: Sort a Protected Worksheet

    yes, I have come to discover that. I moved the column with the protected cells to another location so the sort area was free of any protected columns.

    Thanks for all the replies.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Sort Macro On Protected Worksheet
    By nyte.ex13 in forum EXCEL HELP
    Replies: 7
    Last Post: June 8th, 2008, 14:52
  2. Sort protected worksheet excluding blank cells
    By mustafabrew in forum EXCEL HELP
    Replies: 11
    Last Post: April 3rd, 2007, 16:31
  3. Allow Sorting: Protected Worksheet Doesn't Allow a Sort
    By bandtaskingman in forum EXCEL HELP
    Replies: 2
    Last Post: September 13th, 2006, 10:50
  4. Data Sort with Protected Worksheet
    By murfyang in forum EXCEL HELP
    Replies: 11
    Last Post: February 17th, 2006, 06:53
  5. when sheet in protected cannot sort?
    By liambrown44 in forum EXCEL HELP
    Replies: 3
    Last Post: August 16th, 2004, 22:14

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
  •  
porno