PROTECT CELL CONTENTS/WHILST UTILIZING AUTOFILTER

[Cisco]

I would like to protect the contents of a few cells
in the name/date column while still being able to utilize the auto filter.

However, when I do a cell content protection the auto filter stops working

I did the following to my below data:
1. Selected all my data to be initially unlocked
2. Did Format/cell/protection/clicked unlocked

3. Selected certain cells (below column A headings)to be locked
4. Did Format/cell/protection/clicked locked
5. Did Tools/Protection/Protect Sheet/Select contents

Than the auto feature no longer worked.
Does anyone have any ideas how to keep the auto filter working even after you protect a few cells under the column headings?

P.S. I dont want to spend the $35.00 tech support
to ask such a simple question
just to find out that it cant be done with excel 2000.

Sample data:
Name/Column A Date/Column B

jack 10/2-10/6
jack 10/4-10/12
michelle 10/4-10/13
don 10/4-10/14
michelle 10/2-10/16
ron 10/2-10/16[/b]

 

[DominicB]

Good morning Cisco

Welcome to the board!

If your protection was invoked after your filters were set up then download and install my add-in via the link below. Once done, open the workbook and go to the new dropdown menu Ultimate > Protection > Enable Autofilter. This will leave your protection intact and allow you to use the autofilter.

HTH

DominicB

 

[Richard Schollar]

Hi Cisco

Welcome to the Board!

As Dominic implied, you need to activate Autofilter on the sheet before you protect the sheet as once protected, without alternative code routes or manually unprotecting the sheet, you won't be able to enable autofilter.

 

[DominicB]

Of course, if you're using Excel 2003 (or I think Excel 2002) you could check the Use Autofilter box in the Tools > Protection > Protect Sheet dialog...

HTH

DominicB

 

[Richard Schollar]

Of course, if you're using Excel 2003 (or I think Excel 2002) you could check the Use Autofilter box in the Tools > Protection > Protect Sheet dialog...

Dominic

I must admit I made the assumption that was what the OP was already doing - you still need to enable the autofilter before you protect the sheet though.

 

[DominicB]

Richard

P.S. I dont want to spend the $35.00 tech support to ask such a simple question just to find out that it cant be done with excel 2000.

The OP is using Excel 2000, just pointing out that for the benefit of anyone who doesn't know that you can invoke the sheet protection and opt to keep auotfilter available on Excel 2002 and higher.

HTH

DominicB