protecting formulas without protecting sheet so grouping still wor

[JM]

In excel 2007 I usually protect formulas from being overwritten by users by
selectively locking calculated cells, and then protecting the worksheet.
However, I sometimes need users to be able to use the Group toggle switch to
show or hide various groups of columns, and it appears that protecting the
sheet disables the ability to use Group toggle switches.

Is there a way to protect formulas from being overwriten without protecting
the worksheet itself, perhaps by using some fancy validation formulas?

 

[Shane Devenshire]

Hi,

1. You can write VBA code which rewrite the formula if they change it.
2. You can add button to the spreadsheet which run the grouping command via
a macro and in the process unprotect and then reprotect the sheet.
3. Its possible to write a data validation to prevent the user from writing
over your formula with text or number but it won't stop them from editing
your formulas.