View Single Post
 
Old 01-28-2021, 03:31 PM
Logit Logit is offline Windows 10 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 533
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

In your sorting macro, provide the password to unprotect the sheet first, before the sorting is actually done. Then password protect the sheet at the end.

If the sort will always be alphabetical, include a command button tied to the sort macro. That way the sort will occur in a blink of an eye and the user won't be able to perform any functions on the workbook ... just the sort.
Reply With Quote