Results 1 to 12 of 12

Disable sorting but allow filtering

Threaded View

  1. #1
    Registered User
    Join Date
    04-07-2014
    Location
    Berkshire, England
    MS-Off Ver
    Excel 2010
    Posts
    52

    Disable sorting but allow filtering

    Hello everyone

    I want to prevent sorting of columns in a single worksheet but allow filtering. I came across this macro for Excel 2003 in another forum but it doesn't seem to work for me (I'm using 2010). http://www.ozgrid.com/forum/showthread.php?t=49308

    Formula: copy to clipboard
    Sub Macro1() 
    ActiveSheet.EnableAutoFilter = True
    ActiveSheet.Protect Scenarios:=True, contents:=True, userInterfaceOnly:=True
    End Sub


    I entered it in the view code bit of the worksheet I want it applied to which I'm guessing is the right way to go about it?

    Thanks
    Last edited by EdwardStephenson; 04-23-2014 at 05:48 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 : disable sorting in pivot table
    By somedude in forum Excel General
    Replies: 6
    Last Post: 10-30-2011, 07:42 PM
  2. sorting and filtering
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 07:05 AM
  3. sorting and filtering
    By Duncan McDowell in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  4. Filtering and Sorting
    By pmguerra in forum Excel General
    Replies: 0
    Last Post: 03-17-2005, 12:31 PM
  5. Sorting and filtering
    By dsbiloxi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-10-2005, 08:06 PM

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