| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel 2002 "Protect Sheet", but allow "Hide Columns"?
When using MS Excel 2002: I have turned on "Protect Sheet" to protect some
formulas from being deleted. Prior to turning on protection I unlocked the cells that I wanted users to be able to edit. And I have checked the box to "Allow all users of this worksheet to:" "Delete Columns". What I *don't* see on the "Protect Sheet" menu is an option to "Hide Columns" Do you know of any way that I can allow users to do this, without turning off the protection in MS Excel 2002? |
|
#2
|
|||
|
|||
|
But there is an option to Format Columns.
(and hiding the column is a format change.) VP Safe wrote: When using MS Excel 2002: I have turned on "Protect Sheet" to protect some formulas from being deleted. Prior to turning on protection I unlocked the cells that I wanted users to be able to edit. And I have checked the box to "Allow all users of this worksheet to:" "Delete Columns". What I *don't* see on the "Protect Sheet" menu is an option to "Hide Columns" Do you know of any way that I can allow users to do this, without turning off the protection in MS Excel 2002? -- Dave Peterson |
|
#3
|
|||
|
|||
|
Thank you!!!! That worked!
"Dave Peterson" wrote: But there is an option to Format Columns. (and hiding the column is a format change.) VP Safe wrote: When using MS Excel 2002: I have turned on "Protect Sheet" to protect some formulas from being deleted. Prior to turning on protection I unlocked the cells that I wanted users to be able to edit. And I have checked the box to "Allow all users of this worksheet to:" "Delete Columns". What I *don't* see on the "Protect Sheet" menu is an option to "Hide Columns" Do you know of any way that I can allow users to do this, without turning off the protection in MS Excel 2002? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How do I modify row column format of Excel sheet? | Excel Worksheet Functions | |||
| Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
| hide column but show chart | Charts and Charting in Excel | |||
| Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Linear Mode
