Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel protection "Hidden"
hello community
I am not so sure what is the 'Hidden" checkbox for when I go into the Format Cell dialog box under the Protection Tab. can someone please assist me on what is the function for the 'Hidden" and how can I use it for protecting my worksheet. thanks for kind assistance render -- oldLearner57 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel protection "Hidden"
tikchye_oldLearner57 wrote: hello community I am not so sure what is the 'Hidden" checkbox for when I go into the Format Cell dialog box under the Protection Tab. can someone please assist me on what is the function for the 'Hidden" and how can I use it for protecting my worksheet. thanks for kind assistance render -- oldLearner57 'Hidden' simply refers to whether or not you want the formulas you have written into the particular cell to be visible or not when a user selects that cell. If the box is unchecked the user can see the contents of the cell in the formula bar above the column headers. 'Locked' renders the cell read-only so users cannot change or delete contents. Another thing to remember is that locking or hiding cells has no effect unless you protect the sheet of the workbook you are using. go toolsprotection protect sheet to do so. somethinglikeant |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel document protection | Excel Discussion (Misc queries) | |||
Protection of check boxes in excel 2002 | Excel Discussion (Misc queries) | |||
Excel file protection? | Excel Discussion (Misc queries) | |||
Excel file protection again? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |