| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Hide (limit viewers) to column(s) on a protected worksheet.
Is there away to hide columns & limit the number of viewers that can unhide
the columns (& edit the info) within a protected (read only) Excel spreadsheet. |
|
#2
|
|||
|
|||
|
Make sure that all cells are "Locked" (alt + a -- ctrl + 1 -- protection tab)
Then go to 'Tools' menu - Protection - Protect Sheet or Protect Workbook and assign a password. This will protect the integrity of your workbook/sheet. Good luck, Henrik "RAINCITY.1788" wrote: Is there away to hide columns & limit the number of viewers that can unhide the columns (& edit the info) within a protected (read only) Excel spreadsheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide columns to all but one user? | Excel Discussion (Misc queries) | |||
| Auto Skipping and protected cells | Excel Discussion (Misc queries) | |||
| Cannot Hide Columns | Excel Discussion (Misc queries) | |||
| Increase the limit to number of columns? | Excel Discussion (Misc queries) | |||
| How use group and ungroup functions while worksheet is protected | Excel Worksheet Functions | |||
Linear Mode
