Results 1 to 12 of 12

Disable sorting but allow filtering

Threaded View

EdwardStephenson Disable sorting but allow... 04-17-2014, 11:16 AM
EdwardStephenson Re: Disable sorting but allow... 04-22-2014, 04:31 AM
EdwardStephenson Re: Disable sorting but allow... 04-23-2014, 04:40 AM
TKCZBW Re: Disable sorting but allow... 04-23-2014, 04:46 AM
EdwardStephenson Re: Disable sorting but allow... 04-23-2014, 05:06 AM
TKCZBW Re: Disable sorting but allow... 04-23-2014, 05:10 AM
EdwardStephenson Re: Disable sorting but allow... 04-23-2014, 05:21 AM
TKCZBW Re: Disable sorting but allow... 04-23-2014, 05:27 AM
EdwardStephenson Re: Disable sorting but allow... 04-23-2014, 05:30 AM
TKCZBW Re: Disable sorting but allow... 04-23-2014, 05:43 AM
EdwardStephenson Re: Disable sorting but allow... 04-23-2014, 05:47 AM
TKCZBW Re: Disable sorting but allow... 04-23-2014, 05:50 AM
  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. [SOLVED] sorting and filtering
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 07:05 AM
  3. [SOLVED] 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. [SOLVED] 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