Protect Sheet & Still use filters

[Ben S]

Hi,

I have formulas in certain cells which i would like to protect, say column C

I also need to use filters to enble the user to filter on selected criteria.

Once i protect the sheet, only the relevant columns i a unable to filter

Please help

Thanks in advance

Regards

Ben

 

[Zack Barresse]

hi Ben,

this has been brought up many times before. i am of the personal opinion to upgrade. the newer releases you can designate what the user will be able to do within the worksheet upon protection. i also realize that upgrading is not always possible for everybody. but it's defenitely a benefit of upgrading to a newer version.

HTH

 

[lord of the badgers]

at which version are you able to do this then? seems not to be present in Office 2k which is our work version

 

[Zack Barresse]

sorry, btw, in versions later than 2k.

try this thread:
http://www.mrexcel.com/board2/viewtopic.php?t=52382&highlight=sheet+protection+auto+filter