Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 43
Default Sorting whole Protected 2003 REDUX

We are working in Excel

OS Name Microsoft Windows XP Professional
System Manufacturer Dell Inc.
System Model Precision WorkStation T5400
Microsoft Excel version 11.8320.8221 (Excel 2003 of Office Professional
Edition 2003)

We are trying to sort and filter protected cells.

In the Protect dialog, we have currently highlighted Select locked cells,
Select unlocked cells, Sort, and Use AutoFilter before protecting the sheet.

Of course, we have tried many things to make it work.

The problem is, AutoFilter works with the sheet protected, but Sorting does
not.

We have tried both the Sort option in AutoFilter and the Sort available
under the Data menu.

There are a number of questions and excellent answers that cover this
subject, but they do not seem to cover the issue of how Sorting is allowed
when that option is checked before setting the protection. One does assume
that it is allowed, since it is in the protection check list.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting a protected set of cells ordnance1[_2_] Excel Worksheet Functions 3 December 24th 09 08:23 PM
(redux) PasteSpecialValue doesnt dupe value exactly sometimes (!) joeu2004 Excel Discussion (Misc queries) 0 March 6th 09 01:41 AM
find and return adjacent value (redux)! Todd Lietha Excel Discussion (Misc queries) 3 September 26th 07 01:59 AM
Sorting a protected worksheet in Excel 2003 drusilas Excel Discussion (Misc queries) 0 December 28th 05 11:15 PM
Sorting Protected Worksheet Vonner Excel Discussion (Misc queries) 1 July 16th 05 03:23 PM


All times are GMT +1. The time now is 06:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"