Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection and Auto filter
Hello,
I have have a Tabel that uses the Auto Filter option, i secured my Sheet with: ActiveSheet.Protect DrawingObjects:=False, Contents:=True, Scenarios:= _ False, AllowSorting:=True, AllowFiltering:=True on opening of the document. when I click on the AutoFilter button to Sort Accending it gives me an error message "The cell or chart you are trying to change is protected and therefore read-only" How can i have the fields protected but let it sort? thank you, Daniel Schmidt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel2000/2007 Protection & Auto Filter | Excel Discussion (Misc queries) | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Cell protection & Auto Filter | Excel Worksheet Functions | |||
Auto-Filter Not Working With Protection Turned On | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) |