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]
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]