Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use AutoFilter
I have a protected sheet and would like the on Open event to enable the use
of Autofilters however, my code produces the following resullt ...... For Each ws In Worksheets ws.AutoFilterMode = True Next Run-Time Error 1004, Application defined or object defined error Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use AutoFilter
From help
This property returns True if the drop-down arrows are currently displayed. You can set this property to False to remove the arrows, but you cannot set it to True. Use the AutoFilter method to filter a list and display the drop-down arrows. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Rafi" wrote in message ... I have a protected sheet and would like the on Open event to enable the use of Autofilters however, my code produces the following resullt ..... For Each ws In Worksheets ws.AutoFilterMode = True Next Run-Time Error 1004, Application defined or object defined error Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use AutoFilter
Bob,
Thanks for your response; I think I need to better explain the situation. I have a protected excel file posted to a SharePoint server and I want to make sure that the users will be able to use the autofilters without having to unprotect the file. So my idea was to write a macro that will execute on openning of te file to enable the use of AutoFilters onn a protected sheeet. Thanks again "Bob Phillips" wrote: From help This property returns True if the drop-down arrows are currently displayed. You can set this property to False to remove the arrows, but you cannot set it to True. Use the AutoFilter method to filter a list and display the drop-down arrows. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Rafi" wrote in message ... I have a protected sheet and would like the on Open event to enable the use of Autofilters however, my code produces the following resullt ..... For Each ws In Worksheets ws.AutoFilterMode = True Next Run-Time Error 1004, Application defined or object defined error Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use AutoFilter
You cannot change the sheet protection attributes without unprotecting the sheet
first. To use Autofilter on a protected sheet you must have Autofilter set up prior to protecting the sheet. Your open code must unprotect the sheet, select a range then DataFilterAutofilter then re-protect with the "use autofilter" enabled. Sub Workbook_Open() Sheets("Sheet1").Select With ActiveSheet .Unprotect Password:="justme" .Range("A1:F1").Select Selection.AutoFilter .Protect Password:="justme", DrawingObjects:=True, _ Contents:=True, Scenarios:=True _ , AllowFiltering:=True End With End Sub Gord Dibben MS Excel MVP On Mon, 3 Mar 2008 16:37:01 -0800, Rafi wrote: Thanks for your response; I think I need to better explain the situation. I have a protected excel file posted to a SharePoint server and I want to make sure that the users will be able to use the autofilters without having to unprotect the file. So my idea was to write a macro that will execute on openning of te file to enable the use of AutoFilters onn a protected sheeet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |