hide columns on a protected sheet
 

When using MS Excel 2003: I have turned on "Protect Sheet" to protect some
formulas/Cells from being deleted/changed. Prior to turning on protection I
unlocked the cells that I wanted users to be able to edit.

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 2003?

hide columns on a protected sheet
 

aww i figured it out....

"Rose" wrote:

When using MS Excel 2003: I have turned on "Protect Sheet" to protect some
formulas/Cells from being deleted/changed. Prior to turning on protection I
unlocked the cells that I wanted users to be able to edit.

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 2003?

hide columns on a protected sheet
 

See answer at other post.

No need to multi-post.


Gord Dibben MS Excel MVP

On Thu, 21 Jan 2010 15:50:01 -0800, Rose
wrote:

When using MS Excel 2003: I have turned on "Protect Sheet" to protect some
formulas/Cells from being deleted/changed. Prior to turning on protection I
unlocked the cells that I wanted users to be able to edit.

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 2003?