![]() |
using autofilter and sort, while sheet is protected
Hi,
I would like to protect a sheet but still make sure that people, without the password to unprotect the sheet, can use the sort function and the autofilter function. I use: [Tools Protection Protect sheet] In the option: 'allow all users of this worksheet to: ... I put the mark (v) for: - select locked sells - select unlocked cells - sort - use autofilter When I then close and open the sheet its impossible (without unprotecting the sheet) to use the autofilter of sort function. Does somebody know why? Thanks in advance. Marieke |
All times are GMT +1. The time now is 03:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com