Freezing Formulas Question 2

[Barbara]

I will be more specific as to what I am trying to accomplish. We are a
cabinet company and I have made the sales people a price sheet they will use
on the spot with their laptops to calculate the charges for a customer. It
is set up as follows
Column A Column B Column C Column D
Description Quantity Price Per Unit charge for item

Doors 10 18.00 = 180.00
my formuala is (B2*C2)

This goes on for many more items and then I have it total Column D for the
total charge.

I want to be able to freeze the formulas so they can not be changed by
mistake. When I follow the instructions to freeze formulas it will no longer
let me use the spread sheet to calculate cost by entering any quantities. It
says my spread sheet is locked and I will have to unlock to use and that
defeats my purpose. I know it can be done because I have been supplied the
same type of excel worksheet by a national cabinet supplier. I need to
incorporate their ideas into other things we sell.

Thank you in advance for any help you can give.

Barbara

 

[Carim]

Hi Barbara,

Believe the easiest solution is to have the "sensitive" cells formatted
as Protected,
and to protect the worksheet ...

HTH
Cheers
Carim

 

[Barbara]

I did that but now I am not able to enter quanities. It says the sheet is
protected and I must unprotect to be able to use and that defeats my purpose.

 

[Carim]

Sorry Barbara,

I have not made myself very clear ...
1. all "sensitive" cells have to be formatted as protected , AND
2. all "input" cells have to be formatted as not protected ...

Hope this is clearer ...

Cheers
Carim

 

[MartinW]

Hi Barbara,

Just to explain further. Select the first cell you wish to allow
'user input' in. Then hold down control and click on all the
other 'user input' cells. Once they are all selected let go of
the control button and go to Format>Cells>Security tab
and 'uncheck' the locked option and OK out.

Now when you apply protection you will be able to change
only those cells that have been unlocked.

HTH
Martin

 

[Dave Peterson]

In the English version:
Format|Cells|Protection tab (not Security)

 

[MartinW]

Yeah you're right Dave, can I claim a woops!
or a Freudian slip! Or.... anything but a Bushism!

 

[Barbara]

Thank you so much for your help. You solved a big problem for me.