Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet Data Filters
Is there a way to password protect a data sheet and still be able to use
filters off the title row? We are having trouble with some missing data from time to time. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet Data Filters
Hi Steve
When protecting the sheet you have to check different boxes allowing the users to perform some tasks, there you can check allow autofilter If this helped please say yes, thanks "Steve" wrote: Is there a way to password protect a data sheet and still be able to use filters off the title row? We are having trouble with some missing data from time to time. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet Data Filters
Thanks Eduardo
Feeling stupid. Fixed the problem. "Eduardo" wrote: Hi Steve When protecting the sheet you have to check different boxes allowing the users to perform some tasks, there you can check allow autofilter If this helped please say yes, thanks "Steve" wrote: Is there a way to password protect a data sheet and still be able to use filters off the title row? We are having trouble with some missing data from time to time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filters not working on Protected sheet | Excel Discussion (Misc queries) | |||
A number of auto filters in one sheet. | Excel Discussion (Misc queries) | |||
A number of auto filters in one sheet? Is it possible? | Excel Discussion (Misc queries) | |||
Multiple Filters in one Sheet | Excel Worksheet Functions | |||
How do I save Filters, so that they appear when I open a sheet? | Excel Worksheet Functions |