Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? -- JM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protecting a sheet and keeping grouping | Excel Discussion (Misc queries) | |||
PROTECTING FORMULAS | Excel Discussion (Misc queries) | |||
Protecting Formulas | Excel Discussion (Misc queries) | |||
Protecting Formulas | Excel Discussion (Misc queries) | |||
Protecting Formulas | New Users to Excel |