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?

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

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

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
>

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
>

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
>

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