Does anyone know how to activate a filter on a protected
worksheet without actually unprotecting the sheet?

Any ideas would be appreciated.

Rgs,

Ciara

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

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


.