Use Autofilter in Protected sheet

[swapnasetty]

Hi Everyone,

I am new to Macros. I have the folloing requirement.

In Folder 'X' there is an excel file 'X' containing data.
now i have to run macro from another excel 'Y' which should take excel file 'X' and convert data font to specific format and also protect it.
Was able to complete this requirment successfully.
Now user want to use auto filter funtionality in protected sheet.
I cannot write any code in "X" excel file where there is a data.
In excel "Y" where i have written Macro, i have tried using the following code

If Not ActiveSheet.AutoFilterMode Then
ActiveSheet.Range("A1").autofilter
also
ActiveSheet.EnableAutoFilter = True

but was not able to use auto filter in protected sheet.
Can anyone please help me in solving this Issue.
Thanks in Advance.

Regards,
Swapna.

[dominicb]

Good afternoon swapnasetty

...and welcome to the forum!!

What version of Excel are you using?
If you are using Excel 2002 or greater, when you protect the sheet, scroll down in the protect sheet dialog through all the options, and select Use Autofilter (it's fourth from the bottom).

HTH

DominicB