Excel sort and filter protected cells

by

I have a table where many columns are formulas that I don’t want users to overtype with values, so I have protected the sheet and unlocked the cells they are allowed to edit. However the user needs to be able to sort and filter the table. From what I have read I don’t think this is possible so I think I will need to write macros that unprotects the sheet, then allows the user to enter the sort or filter criteria, then performs the sort or filter, then protects the sheet again. Any guidance on how to write the macro (or how else to approach the problem) gratefully received. Thanks

Answer

  1. Click on “Record Macro”.
  2. Do (manually) what you want the macro to do.
  3. Click on “Stop Recording”.
  4. (If necessary) edit the macro.

Attribution
Source : Link , Question Author : Peter Hawthorn , Answer Author : G-Man Says ‘Reinstate Monica’

Leave a Comment