Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default Sorting protected worksheets

How can I allow sorting of data while preventing changes to a header row?

I find that when, to prevent changes to the header row, I formatted that row
only as Locked and applied Protect Sheet, the Sort function does not then
work even though I check the "Allow all users of this worksheet to ... Sort"
box in the Protect Sheet options.

Excel displays a "The cell or chart you are trying to change is protected
and therefore read-only" message.

Yet if I apply Protect Sheet when the header row is not Locked format, the
Sort option does allow sorting.

Howard


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
Opening Protected EXCEL worksheets to update linked data doctorjones_md New Users to Excel 9 August 7th 06 10:51 AM
Opening Protected EXCEL worksheets to update linked data doctorjones_md Excel Worksheet Functions 9 August 7th 06 10:51 AM
Inserting rows into worksheets that are protected Chris R Excel Worksheet Functions 3 November 18th 05 01:54 PM
Sorting on a protected worksheet Sue Excel Discussion (Misc queries) 6 June 12th 05 09:26 AM
HIDING ROWS IN PROTECTED WORKSHEETS kyoung Excel Discussion (Misc queries) 2 June 9th 05 05:17 AM


All times are GMT +1. The time now is 04:17 PM.

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

About Us

"It's about Microsoft Excel"