Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent other users seeing hidden columns/data | Excel Discussion (Misc queries) | |||
protect cells in excel to prevent users from deleting formulae | Excel Discussion (Misc queries) | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
prevent users from overwriting other users data | Excel Worksheet Functions | |||
Help - Automating a file.. Adding Users , Deleting users, Changing | Excel Worksheet Functions |