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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFilter on a Protected sheet
Hello Olle
Place the code below into the Workbook_Open event: WorkSheets("sheet1").EnableAutoFilter = True WorkSheets("sheet1").Protect contents:=True, userInterfaceOnly:=True HTH Regards Pascal "Olle" a écrit dans le message de ... 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. |
Reply |
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) |