Sort on Protected Fields

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

ActiveSheet.Unprotect Password:="Monkey"
' code that sorts
Activesheet.Protect Password:="Monkey"


of couse you will need to protect your project for viewing so they can not
discover your code.
--
regards,
Tom Ogilvy


"PR" <paul.raeburn@ntlworld.com> wrote in message
news:ebh$7iK5FHA.3188@TK2MSFTNGP15.phx.gbl...
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

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" <paul.raeburn@ntlworld.com> wrote in message news:ebh$7iK5FHA.3188@TK2MSFTNGP15.phx.gbl...
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

version 2003, I have selected to allow sort, but this still does not work
"Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message news:OoBK4wK5FHA.3544@TK2MSFTNGP09.phx.gbl...
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" <paul.raeburn@ntlworld.com> wrote in message news:ebh$7iK5FHA.3188@TK2MSFTNGP15.phx.gbl...
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

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" <paul.raeburn@ntlworld.com> wrote in message news:eEJnXzK5FHA.632@TK2MSFTNGP10.phx.gbl...
version 2003, I have selected to allow sort, but this still does not work
"Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message news:OoBK4wK5FHA.3544@TK2MSFTNGP09.phx.gbl...
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" <paul.raeburn@ntlworld.com> wrote in message news:ebh$7iK5FHA.3188@TK2MSFTNGP15.phx.gbl...
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