PROTECT CELL CONTENTS/WHILST UTILIZING AUTOFILTER

Cisco

New Member
Joined
Oct 22, 2006
Messages
2
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]
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
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

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
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

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
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

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
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

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
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
 

Forum statistics

Threads
1,136,995
Messages
5,679,037
Members
419,801
Latest member
spinjector

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top