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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying in sheet with protection with the use of a macro 5
Protecting worksheet. 1
How do you Determine if a Worksheet is protected? 2
Macro to Un Hide filtered rows 3
VBA Coding Help for Beginner 0
Copy data using macro (with worksheet protect) 5
How to bypass password when pasting FROM a protected workbook 3
Filter a protected shared worksheet 18

Top