Hi Ryton,

Sheets("Sheet 1").Unprotect
"Your code"
Sheets("Sheet 1").Protect

This will unprotect the sheet, run your macro, then protect the sheet again.
Of course, change the Sheet 1 name to your sheet name.

Alan

"The only dumb question is the question left unasked."


"Ryton" wrote in message
ps.com...
G'Day MVPs, OfficeXP Excel question:

My spreadsheet will manually sort fine when it is protected but when
the same sort is attempted via a macro it reports a protection
conflict error. How can I workaround this problem?