Autofilter not working on protected sheet.
Is there a way to ensure that autofilter in excel 2007 remains
operable after the sheet protection is enabled. The cells that are used to set filters' settings are marked as not protected. However, when I click on the drop-down control nothing happens. Ideas? Thanks, folks. |
Autofilter not working on protected sheet.
See
http://www.contextures.com/xlautofilter03.html#Protect -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "parahumanoid" wrote in message ... Is there a way to ensure that autofilter in excel 2007 remains operable after the sheet protection is enabled. The cells that are used to set filters' settings are marked as not protected. However, when I click on the drop-down control nothing happens. Ideas? Thanks, folks. |
All times are GMT +1. The time now is 04:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com