Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I hide data in colums.
I am doing a simple inventory type sheet with multiple columns. I want to
hide data in one column that can't be seen by anyone until I allow it. Is this possible. |
#2
|
|||
|
|||
Gord
Right click on the column header and select Hide. Then protect the sheet (ToolsProtectionProtect sheet...) If you need more than this you will need to use VBA and the xlSheetVeryHidden setting on the visible property of the worksheet object -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Gord" wrote in message ... I am doing a simple inventory type sheet with multiple columns. I want to hide data in one column that can't be seen by anyone until I allow it. Is this possible. |
#3
|
|||
|
|||
Thanks Nick. I hope you don't mind. I sent you an email. But just incase you
didn't get it. I really only want to hide certian cells in a column, not the whole column. Is that possible? "Nick Hodge" wrote: Gord Right click on the column header and select Hide. Then protect the sheet (ToolsProtectionProtect sheet...) If you need more than this you will need to use VBA and the xlSheetVeryHidden setting on the visible property of the worksheet object -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Gord" wrote in message ... I am doing a simple inventory type sheet with multiple columns. I want to hide data in one column that can't be seen by anyone until I allow it. Is this possible. |
#5
|
|||
|
|||
Thanks Nick. That is someting I didn't think about
"Nick Hodge" wrote: Gord You can't but you could colour the font white and stop the user selecting the cell. That way the casual user wouldn't be able to see it, but it would print! -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Gord" wrote in message ... Thanks Nick. I hope you don't mind. I sent you an email. But just incase you didn't get it. I really only want to hide certian cells in a column, not the whole column. Is that possible? "Nick Hodge" wrote: Gord Right click on the column header and select Hide. Then protect the sheet (ToolsProtectionProtect sheet...) If you need more than this you will need to use VBA and the xlSheetVeryHidden setting on the visible property of the worksheet object -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Gord" wrote in message ... I am doing a simple inventory type sheet with multiple columns. I want to hide data in one column that can't be seen by anyone until I allow it. Is this possible. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide column based on data value | Excel Discussion (Misc queries) | |||
Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
Adding more source data to existing scatter plot | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |