![]() |
#2
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sorting in protected worksheet | john64 | Excel | 2 | 12-31-2016 12:04 PM |
sorting data while in a protected workbook | Andy Francis | Excel | 0 | 06-06-2015 01:35 AM |
How can I let my users copy and paste into a protected Word Document? | moden9999 | Word | 4 | 02-02-2015 05:39 PM |
![]() |
skbutler | Excel | 2 | 01-13-2015 05:06 PM |
sheet linking, sorting | nickbfe | Excel | 0 | 05-19-2006 11:00 AM |