Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freezing Formulas Question 2
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freezing Formulas Question 2
Hi Barbara,
Believe the easiest solution is to have the "sensitive" cells formatted as Protected, and to protect the worksheet ... HTH Cheers Carim |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freezing Formulas Question 2
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. -- Barbara "Carim" wrote: Hi Barbara, Believe the easiest solution is to have the "sensitive" cells formatted as Protected, and to protect the worksheet ... HTH Cheers Carim |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freezing Formulas Question 2
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freezing Formulas Question 2
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 FormatCellsSecurity 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freezing Formulas Question 2
In the English version:
Format|Cells|Protection tab (not Security) MartinW wrote: 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 FormatCellsSecurity 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freezing Formulas Question 2
Yeah you're right Dave, can I claim a woops!
or a Freudian slip! Or.... anything but a Bushism! |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freezing Formulas Question 2
Thank you so much for your help. You solved a big problem for me.
-- Barbara "Dave Peterson" wrote: In the English version: Format|Cells|Protection tab (not Security) MartinW wrote: 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 FormatCellsSecurity 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
freezing formulas when cells move | Excel Worksheet Functions | |||
Freezing Formulas | Excel Discussion (Misc queries) | |||
Printing formulas | Excel Discussion (Misc queries) | |||
Question On Excel Formulas | Excel Worksheet Functions | |||
Automatically 'incrementing' formulas for new rows. | New Users to Excel |