ExcelBanter - Filters not working on Protected sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Filters not working on Protected sheet (https://www.excelbanter.com/excel-discussion-misc-queries/219761-filters-not-working-protected-sheet.html)

Krishna Kumar L

Filters not working on Protected sheet

Hi,

I am using tables and filters in my sheet. I am unable to use the filters once I have protected the worksheet. Kindly help.

KK

muddan madhu

Filters not working on Protected sheet

Before protecting the sheet check the option filter.

Tools | protection | protect sheet | give the password ( optional ) |
allow all the users for this worksheet to : check use autofilter
option | ok

On Feb 9, 11:10*am, "Krishna Kumar L"
wrote:
Hi,

* * I am using tables and filters in my sheet. I am unable to use the filters once I have protected the worksheet. Kindly help.

KK

All times are GMT +1. The time now is 08:39 PM.