| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter a protected shared worksheet
How can I filter a protected shared worksheet?
I have allowed filtering in protection & can filter the protected worksheet manually but if I try using vba it says its protected. I can't unprotect then filter because it's a shared workbook. Command used to try to filter is: Selection.AutoFilter Field:=3, Criteria1:="LK", VisibleDropDown:=False -- Regards Neill |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spell Check in Protected Worksheet & Shared Workbook | Excel Discussion (Misc queries) | |||
| Spell Check in Protected Worksheet & Shared Workbook continued | Excel Discussion (Misc queries) | |||
| Turning Filters ON in a Protected Shared Worksheet | Excel Programming | |||
| Filter on a Protected Worksheet | Excel Programming | |||
| shared workbooks - protected worksheet - insert rows | Excel Programming | |||
Threaded Mode
