ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sheet Data Filters (https://www.excelbanter.com/excel-discussion-misc-queries/228644-sheet-data-filters.html)

Steve

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.

Eduardo

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.


Steve

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.



All times are GMT +1. The time now is 03:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com