| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter not working on protected sheet.
Is there a way to ensure that autofilter in excel 2007 remains
operable after the sheet protection is enabled. The cells that are used to set filters' settings are marked as not protected. However, when I click on the drop-down control nothing happens. Ideas? Thanks, folks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofilter not working on protected sheet.
See
http://www.contextures.com/xlautofilter03.html#Protect -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "parahumanoid" wrote in message ... Is there a way to ensure that autofilter in excel 2007 remains operable after the sheet protection is enabled. The cells that are used to set filters' settings are marked as not protected. However, when I click on the drop-down control nothing happens. Ideas? Thanks, folks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use autofilter with macro in a protected sheet | Excel Discussion (Misc queries) | |||
| using autofilter and sort, while sheet is protected | Excel Discussion (Misc queries) | |||
| 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) | |||
![parahumanoid[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
