Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to - sort a protected sheet? | Excel Worksheet Functions | |||
Autofilter in protected sheet | Excel Worksheet Functions | |||
AutoFilter 2003 Excel Protected Sheet | Excel Discussion (Misc queries) | |||
Applying autofilter to protected sheet | Excel Discussion (Misc queries) | |||
can i sort a protected sheet | Excel Discussion (Misc queries) |