Note: All Excel protection is relatively weak. It is useful to stop casual users but it is not for top secret information.
Protection Ex 1
To follow along go to 19.18.1
- Find all the Input Cells and make them blue and unlock them (watch out for the overwritten formula – you need to fix it)
- Protect the sheet so that you can widen rows and columns if necessary
- Create a different password for the Inflation Rate in cell C6
- Make sure no one can enter a marketing percentage less than 10%
Solution