"Tom Ogilvy" wrote in message ...
You didn't say, but have you gotten the code to work with the sheet
unprotected. If not, get it to work with the sheet unprotected, then attack
the protection problem.

Tom

I cannot get it to work even when all the protections on all the
sheets are turned off at design time and all protection code removed.
I created a test sheet with similar functionality to the sort part and
it worked.

I cannot set the takefocusonclick property as it is not a command
button but a custom command bar button being clicked to call the
subroutine.

Doing sheet.unprotect and then sheet.activate has not worked either. I
am pulling out my hair with this one now.

Desperate

--

Rich (change nospam to mlu035 to reply direct)