Need Macro to unprotect worksheet, sort, then protect worksheet
Posted by Carol on October 09, 2001 10:00 AM
Help please! I have a worksheet that needs to stay protected, but the user will still need sort capabilities. I tried to create a macro that would unprotect the sheet, sort, and reprotect. When I tried to run it, it still asked me for the password. Is there a way to create a macro that will store the password so the user doesn't need it? It seems that giving the user the password defeats the purpose. Any help you can give me would be greatly appreciated. Thank you in advance.