| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFilter on a Protected sheet
Hi,
When Autofilter is turned on and the sheet's protection is activated the autofilter buttons are disabled. Does anyone know how to get around this? It works perfect in Excel XP but my client uses Excel 2000 and has no plan to upgrade in the near future. Note, I want to handle this by using VBA. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofilter not working on protected sheet. | Excel Discussion (Misc queries) | |||
| 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 | |||
| Applying autofilter to protected sheet | Excel Discussion (Misc queries) | |||
![Olle[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
