I can unprotect it because I have the password, but it
says the project is locked, so it won't let me do a macro
that would unprotect it, sort it, and then protect it
again. What I'm trying to do is protect the formulas in
the spreadsheet so that other users can't inadvertently
delete them. But, they will need to be able to sort the
spreadsheet. It won't let me sort a protected worksheet.
Any suggestions?
-----Original Message-----
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
.