prevent users from deleting columns
 

Hi
protect the worksheet and not only the workbook

--
Regards
Frank Kabel
Frankfurt, Germany

"Joe" schrieb im Newsbeitrag
...
I am using Excel 2002 and would like to know if tehre is a way to
prevent users from deleting columns in a worksheet. I checked the
Structure protection feature of the Workbook, but this doesn't seem to
be able to do the trick.

Does anyone know if this is possible?

TIA,

Joe

prevent users from deleting columns
 

Frank

The worksheets are protected

Jo

----- Frank Kabel wrote: ----

H
protect the worksheet and not only the workboo

-
Regard
Frank Kabe
Frankfurt, German

"Joe" schrieb im Newsbeitra
..
I am using Excel 2002 and would like to know if tehre is a way t
prevent users from deleting columns in a worksheet. I checked th
Structure protection feature of the Workbook, but this doesn't seem t
be able to do the trick
Does anyone know if this is possible
TIA
Jo

prevent users from deleting columns
 

Hi
this should prevent the user from deleting columns?

--
Regards
Frank Kabel
Frankfurt, Germany

"Joe" schrieb im Newsbeitrag
...
Frank,

The worksheets are protected.

Joe

----- Frank Kabel wrote: -----

Hi
protect the worksheet and not only the workbook

--
Regards
Frank Kabel
Frankfurt, Germany

"Joe" schrieb im
Newsbeitrag
...
I am using Excel 2002 and would like to know if tehre is a way
to
prevent users from deleting columns in a worksheet. I checked
the
Structure protection feature of the Workbook, but this doesn't
seem to
be able to do the trick.
Does anyone know if this is possible?
TIA,
Joe

prevent users from deleting columns
 

Joe

Under ToolsProtectionProtect Sheet there are many options that can be
checked to allow users to change protected sheets.

"Delete Columns" is one of these options.

Gord Dibben Excel MVP

On Fri, 14 May 2004 11:41:04 -0700, Joe
wrote:

Frank,

The worksheets are protected.

Joe

----- Frank Kabel wrote: -----

Hi
protect the worksheet and not only the workbook

--
Regards
Frank Kabel
Frankfurt, Germany

"Joe" schrieb im Newsbeitrag
...
I am using Excel 2002 and would like to know if tehre is a way to
prevent users from deleting columns in a worksheet. I checked the
Structure protection feature of the Workbook, but this doesn't seem to
be able to do the trick.
Does anyone know if this is possible?
TIA,
Joe