Thread: Sorting in protected worksheet
View Single Post
 
Old 12-31-2016, 12:04 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
Have all the cells of the table unlocked.
On the Protect Sheet dialogue, check both Sort and Use AutoFilter.
Reply With Quote