Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-29-2016, 08:38 AM
john64 john64 is offline Sorting in protected worksheet Windows 8 Sorting in protected worksheet Office 2010 64bit
Novice
Sorting in protected worksheet
 
Join Date: Jun 2015
Posts: 2
john64 is on a distinguished road
Default Sorting in protected worksheet

Goodday,

I have a spreadsheet with a protected worksheet. Some of the cells are locked, others aren't.
The problem I have is that I cannot sort in a protected worksheet, although I have set allow sorting when I protected the worksheet

In the attachment there is code for working around, but I don't think it is the nicest way to solve it. By right-clicking on i.e. column header "Date start" you can choose for up- or down sorting.

Anybody have an idea of why I cannot sort in a protected worksheet, using the normal autofilter options ?



regards
John
Attached Files
File Type: xlsm Sorting in protected worksheet.xlsm (19.5 KB, 14 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
sorting data while in a protected workbook Andy Francis Excel 0 06-06-2015 01:35 AM
Unable to "Shift cells down" on unprotected area in a protected worksheet ricky0309 Excel 0 08-14-2014 01:51 AM
Sorting in protected worksheet Cell formating on Protected worksheet AHB Excel Programming 2 02-27-2012 10:25 AM
Sorting in protected worksheet Insert/Paste Picture into Protected Worksheet udea Excel 1 02-06-2012 07:43 PM
Sorting in protected worksheet Word mail merge from a protected Excel worksheet Platform Mail Merge 10 09-28-2011 05:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:43 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft