If users input data to w/sheets they do not need access to cells containing
formulae and therefore those cells should be protected and inaccessible.
Protecting those cells\columns\rows should not compromise filter or sort
functions
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Chris@Preston" wrote:

Can anyone help with the protection of part of an Excel worksheet (Excel
2003)whilst still allowing sorting and filtering of data?
Individual users paste data into the worksheet and, despite comprehensive
instructions, sometimes manage to delete / overwrite existing formulas. The
individual users need to sort and filter the whole worksheet after their
"input" so the basic procedure of locking and protecting the cells containing
the formulas isn't an option. Any help would be most welcome.