RE: Sort and Format a protect Excel Worksheet with a macro

I was able to get Solution 1 to work perfectly. But is there a way to get this code to work for a password protected worksheet. I need the macro to unprotect with the password and then reapply password when it reprotect the worksheet. Thanks in advance for you help. Sorry, but I can’t seem to find the original post in step 1. I can only find it by using Google. Please Google Subject line.