If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
protecting formulas without protecting sheet so grouping still wor
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 |
#2
|
|||
|
|||
protecting formulas without protecting sheet so grouping still wor
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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "JM" wrote: 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 | |
Display Modes | |
|
|