Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Thank You!
"Per Jessen" wrote: Hi To hide cell information, ie formulas select the cell, goto Format Cells Protection Mark "Locked" and "Hidden" Ok Then goto Tools Protection Protect Sheet Password Ok Regards, Per "Beeyen" skrev i meddelelsen ... I have a shared workbook located on the network; the workbook has six worksheets which have to be filled in with information by various people. I have been requested to hide cell information from each of the worksheets. I used the ;;; method to hide the cell of information in the worksheets, which is time consuming but is required. The only problem is I could not hide the formula bar option that would allow a user the view the hidden cell information. The question I have is; how can I hide the formula bar to prevent one from viewing the cell information for this workbook only. Thank you for any assistance you all can offer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What is the command to replace a cell's formula with it's value? | Excel Discussion (Misc queries) | |||
Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
Formula help...right/find command | Excel Discussion (Misc queries) | |||
help create a formula using the IF command with AND | Excel Discussion (Misc queries) | |||
how do i enter data using formula and the Copy command For exa. | New Users to Excel |