Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to i use auto filter on a protected worksheet
my excel list is very long. i want to enable the autofilter to mak
things easy for users going through the database. however, my databas is protected and the filter cant be used on it. so how do i go abou doing it -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to i use auto filter on a protected worksheet
There are instructions here for allowing filtering on a protected
worksheet (the AutoFilter must be in place before the sheet is protected): http://www.contextures.com/xlautofilter03.html#Protect shirley < wrote: my excel list is very long. i want to enable the autofilter to make things easy for users going through the database. however, my database is protected and the filter cant be used on it. so how do i go about doing it? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use auto filter in a protected worksheet | Excel Discussion (Misc queries) | |||
Worksheet protected-auto filter works, show all button dosen't. | Excel Discussion (Misc queries) | |||
Using auto filter after my worksheet is protected | Excel Worksheet Functions | |||
Help with using Auto-filter in a protected Worksheet. | Excel Discussion (Misc queries) | |||
Auto Filter with Protected Worksheet | Excel Worksheet Functions |