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

I am making a utility to share with a group of friends. I am trying to lock
it down and idiot-proof it so it cannot be edited or corrupted. I see in the
Worksheet Protection list there are options for users to be permitted to Auto
Filter and to Sort. If I protect the sheet the Auto Filter still works fine
but the Sort does not. Is this a known bug? Why have Sort as an option in
the list if it doesn't work??
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,722
Default Sorting in a protected sheet

It is not a bug. When you sort the data, you are changing the values of each
individual cell (just moving it somewhere else). Thus, the cells that you
want sorted would need to be unprotected. If you do not allow sorting when
you protect the sheet, you would not be allowed to sort the unprotected data.

If you are needing to lock something down that well, I would recommend
making it read-only (with a password required?). In the battle between
programmers trying to foolproof things, and the universe making a better
idiot, the universe usually wins.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Topgun505" wrote:

I am making a utility to share with a group of friends. I am trying to lock
it down and idiot-proof it so it cannot be edited or corrupted. I see in the
Worksheet Protection list there are options for users to be permitted to Auto
Filter and to Sort. If I protect the sheet the Auto Filter still works fine
but the Sort does not. Is this a known bug? Why have Sort as an option in
the list if it doesn't work??

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 worksheet nigsy Excel Worksheet Functions 4 June 21st 08 11:33 AM
macro for sorting in protected sheet vcff Excel Discussion (Misc queries) 16 October 22nd 07 04:04 PM
Sorting a protected sheet Rusty Excel Worksheet Functions 1 April 19th 07 04:10 AM
sorting protected sheets esslingerdav Excel Worksheet Functions 0 September 19th 06 10:31 PM
Sorting protected worksheets Drr Excel Discussion (Misc queries) 1 December 3rd 04 09:13 AM


All times are GMT +1. The time now is 03:07 AM.

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"