If the workbook is shared, you won't be able to unprotect it. Perhaps
that's the problem.
Phyllis wrote:
Is there any way to sort a protected worksheet? I looked
thru the posts here and found where someone said to create
a macro that unprotected the sheet, then sorted the data,
then protected it again. I tried that, but everytime I
try to create the macro I get this error "Project Locked -
Project is unviewable". Any suggestions?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html