Help with Formulas and cell protection

**swmwshrk** · 07-04-2012, 03:48 PM

In worksheet 1, cell e2 I have a drop down list of 5 items. The end user of the worksheet will select one of these, which will be periodically updated. I want the end users selection to be copied to other worksheets (over 80 in total) to cell e1. Using

Formula:

Please Login or Register  to view this content.

the current selection is properly copied to all my other sheets.

To make sure te end user can't delete or edit the formula and to keep all calculations are correct, I then protect cell e2 on my secondary sheets. As long as protection is off, any changes to sheet1 e2 are copied. Once I turn on protection, the secondary sheets no longer update if worksheet1 e2 is changed. Even after I turn off protection, I have to select cell e2 and hit enter to get the data to change.

My question is How can I keep the end user from accidentlly (or purposely) deleting the formula in e2 on my secondary sheets, yet let it change when the end user changes worksheet 1 e2?

There are formulas on the secondary sheets that rely on this data.

Any and all help is appreciated.

**oeldere** · 07-04-2012, 04:58 PM

You can work with collor.

e.g.
blue is imputcell
yellow is cell with formula
orange is cell with dropdown

Then the user knows what to expect in the cell.

For printing you can turn the page in black/white mode.

**swmwshrk** · 07-09-2012, 08:43 PM

Color is a nice idea but it will still let the end user who may not know excel at all cange the cell contents. I really need these cells protected, as other calculations are dependent on them. One change will mess up the whole workbook.

Sorry it took so long to respond, I saw your reply the day you posted it and I thought i had responded but when I looked today my response wasn't posted.