Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
How can I hide a column in Excel that others I send the sheet or workbook to
cannot unhide, but can still add/modify other information in a sheet or workbook? |
#2
![]() |
|||
|
|||
![]()
You can lock the cells in that column
(select the column|format|cells|protection tab|checked Locked) Unlock the other cells Hide that column protect the sheet (tools|protection|protect sheet) But xl's worksheet protection isn't made for this. It can be broken really quickly. If you have stuff that others shouldn't see, don't put it in a workbook that you share with others. tjenkgrp wrote: How can I hide a column in Excel that others I send the sheet or workbook to cannot unhide, but can still add/modify other information in a sheet or workbook? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Despite formatting a column in Excel 2002 worksheet as Short Date. | Excel Discussion (Misc queries) | |||
hide column but show chart | Charts and Charting in Excel | |||
Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
Excel - hide erroer values | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |