Excel 2000 Protect ... But Free Filter

  • Thread starter Thread starter sal21
  • Start date Start date
S

sal21

I have make a protection on a sheet, it contain a flitre, when i push on
this filtre is not active!!!!!

My problem is activate a protection on sheet and free the filtre....
ARG.....
 
In code in the workbook open event you need to do

worksheets("Sheet1").EnableAutofilter = True
worksheets("Sheet1").Protect UserinterfaceOnly:=True

see help on the protect method for explanation of UsedInterfaceOnly setting.
 
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

selecting filtred range 14
copy last row without header 1
Importing data from Access to Excel 2003 using code 3
Another question about exporting charts 5
Filter on sureport 1
Utilizng full AutoFilter features while specific cells are protect 3
how can I filter by date on my search form 1
Excel Protection 2

Back
Top