Filters on Protected Worksheets
Does anyone know how to activate a filter on a protected
worksheet without actually unprotecting the sheet? Any ideas would be appreciated. Rgs, Ciara |
Filters on Protected Worksheets
Hello Ciara,
Does anyone know how to activate a filter on a protected worksheet without actually unprotecting the sheet? yes that will work: for filters ActiveSheet.EnableAutoFilter = True for outlining ActiveSheet.EnableOutlining = True Look at VBA help for details. Best regards arno |
Filters on Protected Worksheets
Thanks a million that worked a treat.
Regards, Ciara -----Original Message----- Hello Ciara, Does anyone know how to activate a filter on a protected worksheet without actually unprotecting the sheet? yes that will work: for filters ActiveSheet.EnableAutoFilter = True for outlining ActiveSheet.EnableOutlining = True Look at VBA help for details. Best regards arno . |
All times are GMT +1. The time now is 09:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com