Filters on Protected Worksheets

C

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
 
A

arno

Hello Ciara,
Does anyone know how to activate a filter on a protected
worksheet without actually unprotecting the sheet?
Click to expand...

yes that will work:

for filters
ActiveSheet.EnableAutoFilter = True

for outlining
ActiveSheet.EnableOutlining = True

Look at VBA help for details.

Best regards

arno
 
Top