View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris@Preston Chris@Preston is offline
external usenet poster
 
Posts: 2
Default Protecting Excel Formulas

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.