| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to enable the sort function for a protected sheet
After proctecting my sheet with a password, I found that the sort function
will be not available to users without the password. Realized Autofilter can be enabled using codes. What about "sort" function? Thanks. |
|
#2
|
|||
|
|||
|
Not as easily.
You could provide a macro that unprotects the worksheet, does a sort, then reprotects the worksheet. lkjing wrote: After proctecting my sheet with a password, I found that the sort function will be not available to users without the password. Realized Autofilter can be enabled using codes. What about "sort" function? Thanks. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Sort Function | Excel Worksheet Functions | |||
| Sort Function Without Using VBA | Excel Worksheet Functions | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
| Data > Sort function amnesia? | Excel Discussion (Misc queries) | |||
Linear Mode
