sheet protection and autofilter

  • Thread starter Thread starter Imran
  • Start date Start date
I

Imran

Hello All,

I have auto filters my data in the xls worksheet, and also I
have protected the sheet. but after protecting am not able to select from
the
auto filterd combobox. Please send me solution

Thanks In Adv
 
If you are using Excel 2002 then check the Use Autofilter checkbox when
protecting the sheet.

Otherwise you will need to use the following vba code to allow autofilter
and then protect the sheet.

ActiveSheet.EnableAutoFilter = True
ActiveSheet.Protect contents:=True, userInterfaceOnly:=True
 
You must log in or register to reply here.

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

Utilizng full AutoFilter features while specific cells are protect 3
autofilter on a protected sheet 6
protect sheet using vba 1
AutoFilter Slow problem 1
Protection and Auto filter 2
AutoFilter with protected sheets 1
Enable autofilter in protected worksheets in Excel 2000 6
auto-protect a sheet upon workbook close 4

Back
Top