Changing LOOKUP table prices changes previous sales too!

**oeldere** · 08-04-2012, 10:24 AM

There is a possibility to protect a worksheet.

If you have to change the prices often, i don't think protecting the worksheet will help you.

You have to unprotect it before adding new data (prices).

But, like always, look what you're doing.

Compare it with driving a car, when you don't watch the other trafic, you get crashed.

**CaneRivero** · 08-04-2012, 11:06 AM

Good point...and I'm trying...hehehehe.

But, as to the main sheet (rather than the price lookup sheet), any disadvantage to locking down what I don't ever want changed?

Many years ago a popular American television host was interviewing a Hispanic man who spoke English very well but did make occasional small errors. The host, a comedian, made fun of one error in particular causing the Hispanic man to remark: "Remember, Johnny, I know one more language than you do."

Thank you,
Cane

**oeldere** · 08-04-2012, 11:14 AM

"Many years ago a popular American television host was interviewing a Hispanic man who spoke English very well but did make occasional small errors. The host, a comedian, made fun of one error in particular causing the Hispanic man to remark: "Remember, Johnny, I know one more language than you do."" ;)

Personally i'm not a hugh fan of protecting sheets or books, but maybe other forummembers have a differant opion on that.