Hi....I would like to protect some areas of a shared worksheet which has command buttons linked to macros. The macros are used mainly for sorting and its these that im having problems with. When I protect the shared workbook it wont run a sort macro from a command button. I have tried adding a line to the macro unprotecting the sheet and then another line protecting it again but I get "unprotect method of worksheet failed" error message. My ability with VB is very limited and Im using Excel 2007. Hope somebody can help with this.

Many thanks and regards.