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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection and Auto filter
anyone that can help?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection and Auto filter
On 12 Giu, 14:11, TheGerman wrote:
anyone that can help? 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- Nascondi testo citato - Mostra testo citato - Hi German. If I well understood, try: Public Sub prova() ActiveSheet.Unprotect 'your filter instruction or/and 'your sort instructions ActiveSheet.Protect 'with your parameters End Sub Regards Eliano |
Reply |
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) |