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

Sort on Protected Fields
 

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" 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

Sort on Protected Fields
 

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

Sort on Protected Fields
 

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

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