| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding formulas in a Worksheet without password
Greetings
How can I hide and protect formulas in a worksheet that I want to share with other users but don't want to have to use a password? Thanks a bunch! Kant44 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding formulas in a Worksheet without password
You can select the cells with the formulas that should be hidden
Format|cells|protection tab|click locked and hidden Then protect the worksheet (tools|Protection|protect sheet). But don't supply a password. kanti44 wrote: Greetings How can I hide and protect formulas in a worksheet that I want to share with other users but don't want to have to use a password? Thanks a bunch! Kant44 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding formulas in a Worksheet without password
Dave, Thanks!
This does not work because the cells with the formulas are supposed to change when a user makes some selections from drop down lists. Kanti44 "Dave Peterson" wrote: You can select the cells with the formulas that should be hidden Format|cells|protection tab|click locked and hidden Then protect the worksheet (tools|Protection|protect sheet). But don't supply a password. kanti44 wrote: Greetings How can I hide and protect formulas in a worksheet that I want to share with other users but don't want to have to use a password? Thanks a bunch! Kant44 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding formulas in a Worksheet without password
Unlock the cells that are used with the dropdowns.
You don't have to lock all the cells on a worksheet. You don't have to unlock all the cells, either. kanti44 wrote: Dave, Thanks! This does not work because the cells with the formulas are supposed to change when a user makes some selections from drop down lists. Kanti44 "Dave Peterson" wrote: You can select the cells with the formulas that should be hidden Format|cells|protection tab|click locked and hidden Then protect the worksheet (tools|Protection|protect sheet). But don't supply a password. kanti44 wrote: Greetings How can I hide and protect formulas in a worksheet that I want to share with other users but don't want to have to use a password? Thanks a bunch! Kant44 -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding formulas in a Worksheet without password
The dropdowns were unolcked. However, because the formulas cells are
protected, they can only be read (according to the error message). Below is the setup: Selection 1 Selection2 Selection3 Date1 Date2 Date3 SubjetcA Formulas Formulas Formulas SubjectB Formulas Formulas Formulas SubjectC Formulas Formulas Formulas Cells with formulas do change with above selections. Kanti44 "Dave Peterson" wrote: Unlock the cells that are used with the dropdowns. You don't have to lock all the cells on a worksheet. You don't have to unlock all the cells, either. kanti44 wrote: Dave, Thanks! This does not work because the cells with the formulas are supposed to change when a user makes some selections from drop down lists. Kanti44 "Dave Peterson" wrote: You can select the cells with the formulas that should be hidden Format|cells|protection tab|click locked and hidden Then protect the worksheet (tools|Protection|protect sheet). But don't supply a password. kanti44 wrote: Greetings How can I hide and protect formulas in a worksheet that I want to share with other users but don't want to have to use a password? Thanks a bunch! Kant44 -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding formulas in a Worksheet without password
Last line shoiuld read: the numbers in formulas do change with above
selection not "Formulas do change ...." "kanti44" wrote: The dropdowns were unolcked. However, because the formulas cells are protected, they can only be read (according to the error message). Below is the setup: Selection 1 Selection2 Selection3 Date1 Date2 Date3 SubjetcA Formulas Formulas Formulas SubjectB Formulas Formulas Formulas SubjectC Formulas Formulas Formulas Cells with formulas do change with above selections. Kanti44 "Dave Peterson" wrote: Unlock the cells that are used with the dropdowns. You don't have to lock all the cells on a worksheet. You don't have to unlock all the cells, either. kanti44 wrote: Dave, Thanks! This does not work because the cells with the formulas are supposed to change when a user makes some selections from drop down lists. Kanti44 "Dave Peterson" wrote: You can select the cells with the formulas that should be hidden Format|cells|protection tab|click locked and hidden Then protect the worksheet (tools|Protection|protect sheet). But don't supply a password. kanti44 wrote: Greetings How can I hide and protect formulas in a worksheet that I want to share with other users but don't want to have to use a password? Thanks a bunch! Kant44 -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding formulas in a Worksheet without password
I don't understand.
kanti44 wrote: The dropdowns were unolcked. However, because the formulas cells are protected, they can only be read (according to the error message). Below is the setup: Selection 1 Selection2 Selection3 Date1 Date2 Date3 SubjetcA Formulas Formulas Formulas SubjectB Formulas Formulas Formulas SubjectC Formulas Formulas Formulas Cells with formulas do change with above selections. Kanti44 "Dave Peterson" wrote: Unlock the cells that are used with the dropdowns. You don't have to lock all the cells on a worksheet. You don't have to unlock all the cells, either. kanti44 wrote: Dave, Thanks! This does not work because the cells with the formulas are supposed to change when a user makes some selections from drop down lists. Kanti44 "Dave Peterson" wrote: You can select the cells with the formulas that should be hidden Format|cells|protection tab|click locked and hidden Then protect the worksheet (tools|Protection|protect sheet). But don't supply a password. kanti44 wrote: Greetings How can I hide and protect formulas in a worksheet that I want to share with other users but don't want to have to use a password? Thanks a bunch! Kant44 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding Formulas | Excel Discussion (Misc queries) | |||
| Hiding Formulas | Excel Worksheet Functions | |||
| Hiding cells with password | Excel Discussion (Misc queries) | |||
| Locking formulas without password protecting worksheet | Excel Worksheet Functions | |||
| Hiding columns based on user/password | Excel Worksheet Functions | |||
Hybrid Mode
