Filters on Protected Worksheets

[CiaraG]

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

Any ideas would be appreciated.

Rgs,

Ciara

 

[arno]

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

 

[CiaraG]

Thanks a million that worked a treat.

Regards,

Ciara