Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Filter & Protecting Worksheet
Hi there
I want to be able to protect the worksheet so that users can only enter into the data entry cells but also allow them to use the AutoFilter feature to quickly search through the records. When I set the protection feature I can not click on the AutoFilter arrows. Can I change this? Thanks for your help, Silena |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Filter & Protecting Worksheet
See
http://www.contextures.com/xlautofilter03.html#Protect -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Silena K-K" wrote in message ... Hi there I want to be able to protect the worksheet so that users can only enter into the data entry cells but also allow them to use the AutoFilter feature to quickly search through the records. When I set the protection feature I can not click on the AutoFilter arrows. Can I change this? Thanks for your help, Silena |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with using Auto-filter in a protected Worksheet. | Excel Discussion (Misc queries) | |||
Auto Filter with Protected Worksheet | Excel Worksheet Functions | |||
How do I auto-filter multiple ranges on one worksheet? | Excel Worksheet Functions | |||
Auto Skipping and Protecting Worksheet | New Users to Excel | |||
Auto Filter will not work in a new worksheet | Excel Worksheet Functions |