Cell protection & Auto Filter
 

I have an auto filter in cell A1 and locked some cells that have
formulas. I made column A unlocked, yet I stil can't filter. I then
selected rows 1-32, which is the filter and unlocked them, still unable
to. Is it possible to filter while still having cells locked and
protected?


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=540951

Cell protection & Auto Filter
 

fastballfreddy, have a look here,

http://www.contextures.com/xlautofilter03.html#Protect

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"fastballfreddy"
<fastballfreddy.27mutb_1147333801.8443@excelforu m-nospam.com wrote in
message news:fastballfreddy.27mutb_1147333801.8443@excelfo rum-nospam.com...

I have an auto filter in cell A1 and locked some cells that have
formulas. I made column A unlocked, yet I stil can't filter. I then
selected rows 1-32, which is the filter and unlocked them, still unable
to. Is it possible to filter while still having cells locked and
protected?


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile:
http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=540951