Excel 2002 "Protect Sheet", but allow "Hide Columns"? in Excel Worksheet Functions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              VP Safe 6/28/2005 8:38 AM PST   Question   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?     Was this post helpful to you?         Reply |   Top           Dave Peterson 6/28/2005 8:40 PM PST   Answer   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     Was this post helpful to you?         Reply |   Top           VP Safe 7/5/2005 11:12 AM PST   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 >     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies