Filters on Protected Worksheets

  • Thread starter Thread starter CiaraG
  • Start date Start date
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
 
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
 
Back
Top