Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting a formula
Thanks to all your help out there, I've designed a *Killer* sales commission
calculator. I want to be able to send this out to my sales team; there are certain cells that I am requiring them to fill in, then below are cells that contain my formulas. How can I protect certain cells so they don't overwrite my formulas but still give them the ability to manipulate other cells on the same worksheet? Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting a formula
Kim-
You need to select the cells that you want them to have acces to, then format cells and go to the protection tab and unlock those cells. After that, go to tools and protection and you can protect the worksheet. You may add a password or not, but after that only cells that were unlocked prior to protection will be accessible to your sales people. Hope this helps..... Shaun I have a post I need help with if you know anything about linking comments to cells....??? "Kim" wrote: Thanks to all your help out there, I've designed a *Killer* sales commission calculator. I want to be able to send this out to my sales team; there are certain cells that I am requiring them to fill in, then below are cells that contain my formulas. How can I protect certain cells so they don't overwrite my formulas but still give them the ability to manipulate other cells on the same worksheet? Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking portions of a formula | Excel Worksheet Functions | |||
assign formula to another cell | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel |