protecting formulas without protecting sheet so grouping still wor

J

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?
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

backing up formulas in sheet coding? 2
hidng formulas without using protect sheet 1
hide columns on a protected sheet??? 1
Expand/Collapse Grouped Data in Protected Worksheet 6
Protect sheet but still allow use of grouping 3
Hiding rows while sheet is protected 5
Lock cells without protecting sheet? 2
Protect formulas but still allow formatting, etc.? 4

Top