I have a spreadsheet with active columns from A6:X6. Active rows are up
to 10000.

I currently have the section linked and have made a sort macro. This
works well if the sheet is unprotected. But I will need to protect the
sheet in order for people to only enter data where I allow them to and
to protect the formulas in the other cells. With protection on, I
can't sort using the macro.

*Is it possible*: to write a macro that would select unprotect sheet,
type in the password DSKM, perform the alphabetical sort based on colum
B6, then reprotect the sheet using the same password? In other words,
unprotect the sheet only long enough for the sort and then reprotect
it.

Any help would be very much appreciated.

JEN


--
neb
------------------------------------------------------------------------
neb's Profile: http://www.excelforum.com/member.php...o&userid=17597
View this thread: http://www.excelforum.com/showthread...hreadid=388414