ExcelBanter - How To enable the Sort function for a protected Excel sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How To enable the Sort function for a protected Excel sheet (https://www.excelbanter.com/excel-programming/333245-how-enable-sort-function-protected-excel-sheet.html)

lkjing

How To enable the Sort function for a protected Excel sheet

After protecting 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[_5_]

How To enable the Sort function for a protected Excel sheet

See one reply to your post in .misc.

lkjing wrote:

After protecting 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

All times are GMT +1. The time now is 05:15 PM.