Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a list set up within a worksheet and I need to protect the worksheet
and still be able to filter the list. If I select Protect Sheet and check Enable Autofilter then it works but this option prevents me being able to collapse the rows using the grouping. I therefore tried a macro I found here so that the grouping works but this stops my list filter working. The macro I'm using is: Sub workbook_open() With Worksheets("My Sheet Name") .Protect , userinterfaceonly:=True .EnableOutlining = True .EnableAutoFilter = True End With Any suggestions on a command I can include in the macro so the list filter and grouping both work in the protected sheet? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Enabling Autofilter and Sorting in a Protected Sheet | Excel Discussion (Misc queries) | |||
Enabling Spell Check in Protected Worksheet | Excel Discussion (Misc queries) | |||
AutoFilter on Protected Worksheet Excel 2003 | Excel Discussion (Misc queries) | |||
AutoFilter 2003 Excel Protected Sheet | Excel Discussion (Misc queries) | |||
Enabling comments on a protected worksheet | Excel Programming |