A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Sorting whole Protected 2003 REDUX



 
 
Thread Tools Display Modes
  #1  
Old March 29th, 2010, 02:48 PM posted to microsoft.public.excel.misc
SongBear
external usenet poster
 
Posts: 40
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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:41 AM.


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