I have had a look on the forum, but cant find anything to help me
Im a newbie in this so please bear with me
I have tried to edit or rewrite a macro i had for something else but it didnt work as such.
What im trying to do is sort data on a protected sheet that has locked cells.
So what im trying to do is allow the user to select the area he/she wants to sort. Unprotect the sheet, do the sorting in a predetemined order and then lock the sheet.
Sounds easy, but every timei recorded a macro it recorded the sorting area, This is different and therefore it needs to be selected by the user.
Hopes that makes sense
G
Bookmarks