Thread: Sort on Protected Fields
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Sort on Protected Fields
Yes, Sorry the cells that you want to sort can't be locked
The macro solution is the best thing for you

--
Regards Ron de Bruin
http://www.rondebruin.nl


"PR" wrote in message ...
version 2003, I have selected to allow sort, but this still does not work
"Ron de Bruin" wrote in message ...
Which Excel version ?

In 2002-2003 this is a option when you protect your sheet
In 97-2000 you can use a macro to unprotect/Sort/protect

--
Regards Ron de Bruin
http://www.rondebruin.nl


"PR" wrote in message ...
I am trying to Sort on Protected Field and unprotected fields, I have a spreadsheet that I have protected from users, but there is a need for them to sort the data range. Because some of the fields are protected the user gets an error when the macro is run to sort.



Can anyone help

Reply With QuoteReply With Quote